Showing Only the Last Month

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Showing Only the Last Month

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!


Accepted Solutions
Solution
‎07-14-2015 12:34 PM
Super User
Posts: 11,343

Re: Showing Only the Last Month

Posted in reply to emmytheduck

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.

View solution in original post


All Replies
Solution
‎07-14-2015 12:34 PM
Super User
Posts: 11,343

Re: Showing Only the Last Month

Posted in reply to emmytheduck

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.

Occasional Contributor
Posts: 15

Re: Showing Only the Last Month

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!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 170 views
  • 1 like
  • 2 in conversation