I am using a databank to isolate subjects with a diagnosis (dcode) from a specific list. In the dataset, each subject (using the identifier inc_key) may have multiple rows if they have more than one diagnosis. In my code I first created a dummy variable (tbi) for each observation that had a diagnosis of interest. Then I tried to extract only subjects with a "tbi" diagnosis, and not use any subjects that either had no "tbi" or that had tbi+ something else. It didn't work though, and Im not sure why. Help would be much appreciated! macro for the diagnoses Im interested in: data _null_; length list $30000 ; do x=800.0 to 801.9 by 0.01 ,803.0 to 804.9 by 0.01 ,850.0 to 854.1 by 0.01 ,950.1 to 950.3 by 0.01 ,959.01 ,995.55 ; list=catx(' ',list,put(x,6.2)); end; call symput('list',list); run; creating dummy variable for tbi: data mt2.tbi1;set ntdb15.rds_dcode; by inc_key; tbi=0; if dcode in (&list) then tbi=1; run; output only subjects that have tbi diagnosis and no others: data mt2.tbiplus ;set mt2.tbi1; by inc_key; if first.inc_key=last.inc_key; if tbi=0 then delete;run;
... View more