topic Re: Get month from a date format in SAS Procedures

Get month from a date format

podarum — Wed, 24 Oct 2012 18:43:33 GMT

Hi, I havea data format as such MMDDYYP10. (samples below), I'm trying to get the months out of the dat but in a MONNAME. format.

Have

Date

05.02.2012

06.14.2012

07.04.2012

I used

Date_A = Month (Date);

Format Date_A MONANME. but this didn't quite work

Want

Date_B

May

June

July

Re: Get month from a date format

Reeza — Wed, 24 Oct 2012 18:54:37 GMT

The monname format uses a date variable not a month variable.

date_a=date;

format date_a monname10.;

format date monname10.;

Re: Get month from a date format

podarum — Wed, 24 Oct 2012 19:08:15 GMT

Thank you

Re: Get month from a date format

podarum — Wed, 24 Oct 2012 19:34:26 GMT

Hi Reeza, when I export it to Excel the date_a doesn't come across as only Month , but as the whole date similar to date. In SAS it shows correct, how I would like it to.

Re: Get month from a date format

Reeza — Wed, 24 Oct 2012 21:00:08 GMT

You exported the data with proc export?

By definition SAS does not export formats to Excel using proc export.

Instead you can create a new variable using the put statement that will recode the data and then export.

data_a=put(date, monname10.);

Re: Get month from a date format

AncaTilea — Wed, 24 Oct 2012 21:40:29 GMT

Hi.

PROC EXPORT does not keep formats, but the ODS tagsets does.

Below is a sample code that will keep ALL your formats.

       ods listing close;
             ods tagsets.excelxp path = "&output_path." file="&data..xml"
             style=analysis      options(absolute_column_width='10,10,8,8,10,10,15,8,15,8,15,10,8,8,8,8,10,10,15,8,15,8,15,10,8,8,8,8,20'
        sheet_label=' ');

ods tagsets.excelxp options(sheet_name="sheetname");

             proc print noobs label data = &data.;
                 var your_variables;
             run;
        ods tagsets.excelxp close;
        ods listing;

Good luck!