12-24-2015 09:22 PM
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.
12-24-2015 10:08 PM
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;