Changing date format

AnaV — Wed, 20 Feb 2013 23:07:45 GMT

Hi,

I imported several datasets from excel to sas using the proc import function. Following that I created a new dataset, TotalOwn. which combined all of the imported datasets. I realized that my dates were read as best32. and I need to convert them into yymmdd10. format. Is there a way to do it for the combined dataset, TotalOwn? instead of modifying it for every single dataset that I imported?

I tried using the proc datasets function:

proc datasets lib=own1990;

modify TotalOwn; format fdate yymmdd10.; informat fdate best32.; run;

But It's been over an hour and it appears to still be running.

Thank you for your help,

Re: Changing date format

Reeza — Wed, 20 Feb 2013 23:17:52 GMT

proc datasets needs a 'Quit;' as well as run;

topic Re: Changing date format in SAS Programming

Changing date format

Re: Changing date format