topic Re: How to select specific obs of a variable in New SAS User

How to select specific obs of a variable

hjjijkkl — Wed, 10 Feb 2021 20:02:44 GMT

I have a data similar to this and I want to select the last visit for each individual. How would I do that?

I want an output like this (I don’t want to include those that have only one visit)

Shmuel — Wed, 10 Feb 2021 20:13:10 GMT

Assuming VISIT is a numeric sas date variable then do:

proc sort data=jave; by ID visit; run;

data want;
 set have;
  by ID visit;
     if last.ID;
run;

ballardw — Wed, 10 Feb 2021 23:51:05 GMT

Since the request included "(I don’t want to include those that have only one visit)", I propose the below modification to @Shmuel's solution

proc sort data=have; by ID visit; run; data want; set have; by ID visit; if last.ID and not(first.id); run;