About OnSAS

OnSAS · ‎08-10-2017

You are welcome! glad I was able to.

OnSAS · ‎08-10-2017

Here, I think you are clearly better of using a data step. in the data step you can create a new variable that takes the min of all the ones you've created. For example: IndDiab = min (of DIABETES_1_1 -- DIABETES_<n>_<m>); replace n & m with values IndDiab will take 0 when none of the variable in the list is 1. good luck.

OnSAS · ‎08-09-2017

You can go all macro on it, here is a sketch: %macro t; PROC SQL; CREATE TABLE MOM_2 AS SELECT * %do i=1 %to 3; %do j=1 %to 4; ,CASE WHEN MOM_ID IN (SELECT MOM_ID FROM MOM_1 WHERE COMPRESS (DX_CODE&i._visit&j.) BETWEEN "XX.XX" AND "XX.XX") THEN 1 ELSE 0 END AS DIABETES_&i._&j. %end; %end; END AS DIABETES FROM MOM_1; QUIT; %mend t; %t;

OnSAS · ‎08-09-2017

Did you try input function ? a = input(variablename, best12.);

Online Status	Offline
Date Last Visited	‎02-27-2018 02:24 PM

Re: Multiple variables for same condition PROC SQL

Re: Multiple variables for same condition PROC SQL

Re: Multiple variables for same condition PROC SQL

Re: Converting $1. to best12

Re: Multiple variables for same condition PROC SQL

Re: Multiple variables for same condition PROC SQL

Re: Multiple variables for same condition PROC SQL

Re: Multiple variables for same condition PROC SQL

Re: Converting $1. to best12