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
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.
That looks like and E8601DT16. informat should work.How to specify that may differ depending on exactly how your read the CSV
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;
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;
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.