topic reading the day number from a SAS date in New SAS User

reading the day number from a SAS date

elopomorph88 — Mon, 26 Jul 2021 20:41:08 GMT

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.

Re: reading the day number from a SAS date

novinosrin — Mon, 26 Jul 2021 20:43:13 GMT

Use DAY function

day(date);

Re: reading the day number from a SAS date

PaigeMiller — Mon, 26 Jul 2021 21:01:26 GMT

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.

Re: reading the day number from a SAS date

Reeza — Mon, 26 Jul 2021 20:59:54 GMT

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.