topic How to read this time and time in SAS? in SAS Procedures

How to read this time and time in SAS?

Palang — Mon, 17 Oct 2016 17:28:17 GMT

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

Re: How to read this time and time in SAS?

ballardw — Mon, 17 Oct 2016 17:32:03 GMT

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

Re: How to read this time and time in SAS?

Palang — Mon, 17 Oct 2016 17:39:08 GMT

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;

Re: How to read this time and time in SAS?

ballardw — Mon, 17 Oct 2016 17:54:26 GMT

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;

Re: How to read this time and time in SAS?

Palang — Mon, 17 Oct 2016 18:08:07 GMT

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.