BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Krysia24
Obsidian | Level 7

Currently I am working with a dataset where each row of data is a birth corresponding to a mother (where the mother is identified by a uniqueid variable). A mother may have multiple births in the dataset but I am only interested in the most recent birth for each mother. The babydob variable is being used since it will help us extract the most recent birth. This is the code I am attempting to use:


PROC SORT data=births;
BY babydob uniqueid;
RUN;

DATA births2;
SET births;
BY babydob;
IF last.babydob;
RUN;

 

When I tested to see if my code worked, I still got some mothers with multiple births on different dates, when I just want the last one.

 

So I got something like this:

 

UniqueID     babydob

001              01/01/2010

001              01/01/2012

001              01/01/2016

002              02/02/2012

 

But what I want is:

 

UniqueID       babydob

001               01/01/2016

002               02/02/2012 

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

correction:

PROC SORT data=births;
BY uniqueid babydob ;
RUN;

DATA births2;
SET births;
BY uniqueid babydob ;
IF last.uniqueid ;
RUN;

View solution in original post

1 REPLY 1
novinosrin
Tourmaline | Level 20

correction:

PROC SORT data=births;
BY uniqueid babydob ;
RUN;

DATA births2;
SET births;
BY uniqueid babydob ;
IF last.uniqueid ;
RUN;

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 703 views
  • 0 likes
  • 2 in conversation