Hey all! I'm quite new to SAS. I am working with a large data set that lists members with their coverage dates. So, if I were a member and I had coverage for the entire year, there are 12 rows for me with 1/1/15, 2/1/15, and so on all the way to December.
I want to show just ONE line for each member. I need it to be the last month of coverage. For most, it will be December. I was told to use "last.incmth" (incmth is the variable). I'm not having any luck, and I don't want to make this too complicated if possible. Thank you!
Actually you likely want the last member ID value. A stub of code that should accomplish this is:
If the data is sorted this step isn't needed but just in case:
proc sort data=have; by memberid incmth; run;
Then to get the data you want:
Data want;
set have;
by memberid incmth;
if last.membered;
run;
IF the data crosses Years and you need the last within each year you would need to add a Year value to use in the by statement: by membered year incmth;
and use last.year to get the last value for each year associated with a member.
Actually you likely want the last member ID value. A stub of code that should accomplish this is:
If the data is sorted this step isn't needed but just in case:
proc sort data=have; by memberid incmth; run;
Then to get the data you want:
Data want;
set have;
by memberid incmth;
if last.membered;
run;
IF the data crosses Years and you need the last within each year you would need to add a Year value to use in the by statement: by membered year incmth;
and use last.year to get the last value for each year associated with a member.
ballardw - Thank you! I actually figured it out right before you posted. I forget that I need to focus on the variable that is causing the duplicates. Thank you!
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.