topic Date to Month Format in SAS Procedures

Date to Month Format

BETO — Thu, 23 Feb 2012 18:22:19 GMT

The issue is I have a column with " On time" which displays 02/20/12 I used MONAME to format to Month "Feb "which is great in my SAS table. The issue is when I export to excel it converts it back 02/20/12 . What can I do to keep the format of Feb ? Thanks for your assitance

Re: Date to Month Format

Haikuo — Thu, 23 Feb 2012 18:23:56 GMT

You probably need to convert it into character. Excel will not recognize SAS format.

Edit: something like:

data _null_;

a=input ('2/20/12', mmddyy8.);

b=put(a,monname3.);

put a b;

run;

Regards,

Haikuo

Date to Month Format

art297 — Thu, 23 Feb 2012 18:31:00 GMT

I agree we Haikuo. Create a new variable to export. e.g.:

data have;

informat on_time mmddyy8.;

input on_time;

on_time_month=put(on_time,monname3.);

cards;

02/20/12

03/14/12

;

Date to Month Format

BETO — Mon, 27 Feb 2012 07:41:05 GMT

HI Art,

I've a table named 'All' it has 30 columns . Using your data step how would I tie it together to convert my date of 4000 entries to reflect Month but keep the columns . I tried rename my table to the data step 'Have' to ALL an it removed the rest of the columns

Thanks again for your assitance in this matter

Date to Month Format

Ksharp — Mon, 27 Feb 2012 07:45:38 GMT

try something like

data all;

set all;

on_time_month=put(on_time,monname3.);

run;

Ksharp

Date to Month Format

art297 — Mon, 27 Feb 2012 13:45:31 GMT

The code that both Ksharp and I suggested would take care of it for all 4,000 of your records. I'm not sure what you actually did, as you didn't post the code that you ran.