topic Re: Showing Only the Last Month in SAS Programming

Showing Only the Last Month

emmytheduck — Tue, 14 Jul 2015 15:35:42 GMT

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!

Re: Showing Only the Last Month

ballardw — Tue, 14 Jul 2015 16:34:43 GMT

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.

Re: Showing Only the Last Month

emmytheduck — Tue, 14 Jul 2015 18:22:23 GMT

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!