DATA Step, Macro, Functions and more

Help

Accepted Solution Solved
Reply
Contributor
Posts: 60
Accepted Solution

Help

Hi I need some help to calculate the Member age at end of the month each month. I have Member's date of the birth and Reporting end date.

 

Thank You

Ahsan


Accepted Solutions
Solution
‎12-26-2017 03:51 PM
Super User
Posts: 3,778

Re: Help

Something like this should do it:

 

AgeinYears = INTCK('YEAR',BirthDate, ReportDate, 'C');

Here is a link to the function:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p1md4mx2crz...

View solution in original post


All Replies
PROC Star
Posts: 1,357

Re: Help

Where is your sample input and wanted output dataset and why is this question posted on 

Contributor
Posts: 60

Re: Help

Posted in reply to novinosrin
I am new here so I don't know where to post it.
Contributor
Posts: 60

Re: Help

Posted in reply to novinosrin

I need to verify this variable in the data base

 

MBR_AGE_EOM   TEST_AGE
         20            
         20            
         20            
         20            

Solution
‎12-26-2017 03:51 PM
Super User
Posts: 3,778

Re: Help

Something like this should do it:

 

AgeinYears = INTCK('YEAR',BirthDate, ReportDate, 'C');

Here is a link to the function:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p1md4mx2crz...

Contributor
Posts: 60

Re: Help

Thank you it works
Super User
Posts: 9,612

Re: Help

I moved this topic to Base SAS Programming, where it belongs.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

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

Discussion stats
  • 6 replies
  • 252 views
  • 0 likes
  • 4 in conversation