proc sort data=have nodupkey;
by id date;
run;
data want;
set have;
by id date;
if first.id then index=1; else index=2;
run;
proc freq data=want;
tables cat1*cat2;
where index=1;
run;
I prevoiusly used index=2 to mark if those obs have multiple records (visits). But this has limitation, only the later visits are counted. This time I need to mark, if the patient has mulitple visit (might see doctors same day many times), whether it is the first visit, or the later visit, I want to create a variable that the patient has "multiple visit"
That means, if index=2, all the patient's records will mark as "multipe visit"
Any idea how to do? Thanks.
Assuming that your PROC SORT is doing the correct thing by removing multiple visits for the same patient on the same date ...
Try creating INDEX this way:
if first.id and last.id then index='Just one';
else index='Multiple';
Then adjust the WHERE statement to select whichever patients you would like.
Assuming that your PROC SORT is doing the correct thing by removing multiple visits for the same patient on the same date ...
Try creating INDEX this way:
if first.id and last.id then index='Just one';
else index='Multiple';
Then adjust the WHERE statement to select whichever patients you would like.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.