How to read this time and time in SAS?

[Palang]

Hello,

I need to read a CSV dataset in SAS that has time-date format like this: 2015-01-01T00:00

It would be appreciated if help me read this time-date in SAS.

Thanks

[ballardw]

That looks like and E8601DT16. informat should work.How to specify that may differ depending on exactly how your read the CSV

[Palang]

Thank you for your response. But this informat does not work with the following piece of code:

data diss.rawdata (drop=fname);
length myfilename $100;
length name $25;
set diss.dirlist;

informat Interval E8601DT16.;

filepath = "&dirname\"||fname;
infile dummy filevar = filepath length=reclen end=done FIRSTOBS=2 /*obs=4*/ missover dsd;

do while(not done);
myfilename = filepath;

input STID $ Interval : $16.
RELH TAIR WSPD WVEC TA9M WS2M;

format Interval datetime22.;

Date=datepart(Interval);
Time=timepart(Interval);
output;
end;

drop myfilename name;
*format Date MMDDYY10. Time hhmm.;
run;

[ballardw]

INFORMATS are used by INPUT statements in a data step.

When you use this code:

input STID $ Interval : $16.

You told SAS to read your interval variable as character 16.

try replacing these lines:

input STID $ Interval : $16.
RELH TAIR WSPD WVEC TA9M WS2M;

with

input STID $ Interval
RELH TAIR WSPD WVEC TA9M WS2M;

[Palang · Accepted solution]

Thank you very much for your respone. That was actually my mistake in defining variable "Interval". Iused the folloing informat with other formats and it worked.

input STID $ Interval : B8601DT.;

Thank you.