topic Re: Categorizing data by SAS date in month year monyy7. format in SAS Programming

Categorizing data by SAS date in month year monyy7. format

Sushma1 — Mon, 29 Aug 2016 14:16:26 GMT

Hi all,

I have one data set in which there is total number of case of a disease by date. The date is in Month, Year e.g Jan 2015, Feb 2015, Jan 2016 format. I want to categorize the number of cases by date e.g. before Jan 1915 and after Jan 1915. I could not perform function like if date<Jan 1915 as I would do with the numeric data.

Please help.

Thanks!

Re: Categorizing data by SAS date in month year monyy7. format

Reeza — Mon, 29 Aug 2016 14:22:38 GMT

You specify a SAS date literal as 'ddMonyy'd

For example:

'01Jan1915'd

Re: Categorizing data by SAS date in month year monyy7. format

Sushma1 — Mon, 29 Aug 2016 14:25:57 GMT

It works !! Thank you very much for the quick reply.