BookmarkSubscribeRSS Feed
vpgodbole
Fluorite | Level 6

Creation date can be even before JAN 2015, but table is only for months of JAN2015 to DEC2018. 

That means for JAN 2015, claims created on or before JAN2015 and closed after or missing would be pending for JAN2015.

 

So basically i have to take entire data into consideration but calculate only for months i want. 

will test coalesce now, thanks.

ballardw
Super User

@vpgodbole wrote:

Creation date can be even before JAN 2015, but table is only for months of JAN2015 to DEC2018. 

That means for JAN 2015, claims created on or before JAN2015 and closed after or missing would be pending for JAN2015.

 

So basically i have to take entire data into consideration but calculate only for months i want. 

will test coalesce now, thanks.


I showed how to make an ENDMONTH variable. Use the same approach to create a STARTMONTH value and then use Pending from Startmonth to Endmonth. Instead of COALESCE though you likely want to take the MAX value of the create date and your year start date.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

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
  • 16 replies
  • 1576 views
  • 1 like
  • 4 in conversation