Hello, I have found a solution to code concomitant medication use in SAS, but my code runs with error. Any suggestions on how to proceed? ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid. data have;
input ID DRUG $ START_DT :mmddyy. DAYS_SUPP END_DT :mmddyy.;
datalines;;
1 A 2/17/10 30 3/19/10
1 B 5/6/09 30 6/5/09
1 C 7/9/11 60 9/7/11
1 E 3/1/10 90 5/30/10
1 B 1/1/09 90 4/1/09
1 D 2/1/09 30 3/3/09
1 C 5/6/12 90 8/4/12
2 B 4/1/12 60 5/31/12
2 A 7/1/10 30 7/31/10
2 C 8/3/10 90 11/1/10
2 D 11/1/13 90 1/30/14
2 E 12/5/13 90 3/5/14
2 A 2/1/11 90 5/2/11
2 F 12/16/13 30 1/14/14
;
data days;
set have;
dum = 1;
do day = start_dt to end_dt; by id;
output;
end;
format day yymmdd10.;
keep id drug day;
run;
proc sort data=days; by id day drug; run;
... View more
