DATA Step, Macro, Functions and more

Help with Date Time format and importing data

Reply
Occasional Contributor
Posts: 5

Help with Date Time format and importing data

Hello

My date comes in through this format in my .txt file   2013-10-02 00:00:00.000

 

I am new to programming and have tried many ways to bring in the data but it conitues to come in bad. Ive even tried to bring it in as text, then use a substring and then convert it to date (but stuck on that last piece now)

 

Can you guys please help? I need get the date in MMDDYY10.

 

Thanks!

 

Respected Advisor
Posts: 4,925

Re: Help with Date Time format and importing data

If you just need the date part then skip the time part of the field :

 

data test;
attrib myDate format=mmddyy10. informat=yymmdd10.;
input myDate dum $ other;
drop dum;
datalines;
2013-10-02 00:00:00.000 123
;

proc print data=test noobs; run;
PG
Ask a Question
Discussion stats
  • 1 reply
  • 144 views
  • 0 likes
  • 2 in conversation