Time Informat/Format for mm/33/yyy hh:mm:ss am/pm from csv file for input line

[lburda]

Hello,

I'm trying to import a csv file that looks like this:

I want to separate date and time into two variables, but I can't find the correct informat/format to even import it as date/time together. I know how to separate the date and time parts once I can get the initial date/time imported into my dataset.

Thank You.

[Reeza · Accepted solution]

I would suggest separating it after the fact. Assuming it gets imported as a datetime, you can then use the DATEPART() and TIMEPART() function.

You can do it in the same step as you import your data though, assuming you're using a data step.

data want;
infile 'path to csv file' dsd truncover;
informat date_time anydtdtm. unit $10. Value 12.3;
input date_time unit value;
date=datepart(date_time);
time=timepart(date_time);

format date_time datetime22. date date9. time time8.;
run;

[lburda]

Thank you, this worked perfectly!