02-20-2013 06:07 PM
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,