Hello Everybody!
I've got a data set and I'm trying to create a variable that will flag the last Encounter_Date for each patient for each fiscal month/fiscal year. They may have multiple encounters on the last Encounter_Date. I'm trying to replicate the results of this code:
proc sql;
create table bbb as select * from aaa
group by fy, fm, ppid
having encounter_date = max(encounter_date);
quit;
with something like this (I want to keep all records in aaa and flag the max(encounter_date)):
proc sort data = aaa;
by FY FM ppid encounter_date;
run;
data bbb;
set aaa;
by FY FM ppid;
if last.ppid then Max_Enc_Date = 1 ;
else Max_Enc_Date =0 ;
run;
Thanks,
Brian
... View more