02-23-2012 01:22 PM
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
02-23-2012 01:23 PM
You probably need to convert it into character. Excel will not recognize SAS format.
Edit: something like:
a=input ('2/20/12', mmddyy8.);
put a b;
02-23-2012 01:31 PM
I agree we Haikuo. Create a new variable to export. e.g.:
informat on_time mmddyy8.;
02-27-2012 02:41 AM
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
02-27-2012 08:45 AM
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.
Need further help from the community? Please ask a new question.