Changing date format

[AnaV]

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,

AV

[Reeza]

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