BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Palang
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Palang
Obsidian | Level 7

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.

View solution in original post

4 REPLIES 4
ballardw
Super User

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

 

Palang
Obsidian | Level 7

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
Super User

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
Obsidian | Level 7

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2027 views
  • 1 like
  • 2 in conversation