Hi, I am trying to create a binary variable (eg. diabetes) satisfying the condition - at least 2 outpatient visits >= 7 days apart then binary variable is 1, else 0. I made it work for 1 variable here - o_diab (code below). However I need it to loop through 27 variables and create 27 flag variables. Basically the o_diab needs to be looped to include all 27 variables and (1/0) variables such as diabetes needs to be created. Can someone please help? Thanks! (27 variables are = o_angina o_anemia o_alc o_cad o_coag_def o_chf ...............................................) proc sql; create table want as select distinct id, index_date, min(case when inpatient=0 and o_diab=1 then clm_from else . end) as firstDT_o_diab format date9., max(case when inpatient=0 and o_diab=1 then clm_from else . end) as lastDT_o_diab format date9., (case when calculated lastDT_o_diab - calculated firstDT_o_diab>=7 then 1 else 0 end) as diabetes from raw; quit;
... View more