topic Re: EG or CODE- change dob format ( from text to date) , calculate age in SAS Programming

EG or CODE- change dob format ( from text to date) , calculate age

deleted_user — Thu, 04 Nov 2010 16:08:50 GMT

How can I change date format from text to date :
then create the variable called age to calculate the account age.

How to in Enterprise Guide ?
How to in code ?

Re: EG or CODE- change dob format ( from text to date) , calculate age

Patrick — Thu, 04 Nov 2010 17:03:17 GMT

Hi

To convert a date string to a number representing a SAS date use a informat. Which informat to use depends on the form of the date string you have.

You could try:
SASDateVar=input(DateStringVar,anydtdte.);

Age in days would then be:
Age=today() - SASDateVar;

If you have to calculate the age based on a year with 360 days then look up function DATDIF() in the Base SAS documentation.

HTH
Patrick

Re: EG or CODE- change dob format ( from text to date) , calculate age

deleted_user — Fri, 05 Nov 2010 14:55:52 GMT

Thank you !! that works perfect