Help with Date Time format and importing data

val843 — Fri, 25 Dec 2015 02:22:16 GMT

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!

Re: Help with Date Time format and importing data

PGStats — Fri, 25 Dec 2015 03:08:14 GMT

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;

topic Help with Date Time format and importing data in SAS Programming

Help with Date Time format and importing data

Re: Help with Date Time format and importing data