reading the day number from a SAS date

[elopomorph88]

I have a column of data in the SAS format of DATE9.   I want to just read the day number from the date from this column of data.  For example, one of the dates is 09Sep21 and I want to read the day of 9 from this data.  So any advice on how to read the day number from a SAS date would be greatly appreciated.  

[novinosrin]

Use DAY function

day(date);

[PaigeMiller]

and for anyone else reading along, if you want the month you can use

month(date)

and if you want the year, you can use

year(date)

The format of the variable is irrelevant when you use the DAY() or the MONTH() or the YEAR() function; however the variable must be numeric, and the variable must be a valid SAS date (number of days since 01JAN1960) and not something like 090921 which is not a valid SAS date.

[Reeza]

Day function if you need to convert it, Day format if you want to summarize by day across various months and want to avoid having to create a new variable.