topic Re: SAS Date format - want to have only month in SAS Enterprise Guide

SAS Date format - want to have only month

Rish — Thu, 06 Sep 2012 20:43:23 GMT

Gurus -

I want to pull only the month from the datasets. Currently the date is stored as example 12Aug2012. I just need Aug.

Thanks in advance.

Re: SAS Date format - want to have only month

ballardw — Thu, 06 Sep 2012 21:39:46 GMT

Is the value a SAS date, i.e. numeric with a default format of Date9. or is it string?

If a SAS date then you can change the format Monname3. and it will display as Aug.

If need to select a specific month (not including year) of data you can use

if month(datevariablename) = 8; or the number of the month you want if the variable is a SAS date.

Re: SAS Date format - want to have only month

Rish — Thu, 06 Sep 2012 21:45:14 GMT

Hi Ballarw -

If we are using proc sql example Select Month(xxxdate) gives me numeric "8", do you know how to change it to display "Aug".

Thanks

Re: SAS Date format - want to have only month

PGStats — Thu, 06 Sep 2012 22:30:53 GMT

You can use

select month(xxxdate) as month format=NLSTRMON3.1, ...

this works for locale=English_UnitedStates, for other locales you must adjust the field width. For example, for locale=French_Canada, you must use NLSTRMON5.1 .