BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Bal23
Lapis Lazuli | Level 10
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.

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

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.

View solution in original post

1 REPLY 1
Astounding
PROC Star

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.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 814 views
  • 0 likes
  • 2 in conversation