Changing date format

Reply
Contributor
Posts: 20

Changing date format

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

Super User
Posts: 17,829

Re: Changing date format

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

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 1 like
  • 2 in conversation