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

[deleted_user]

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 ?

[Patrick]

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

[deleted_user]

Thank you !! that works perfect