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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.