Help using Base SAS procedures

How to read this time and time in SAS?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

How to read this time and time in SAS?

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


Accepted Solutions
Solution
‎10-17-2016 02:08 PM
Occasional Contributor
Posts: 13

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

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


All Replies
Super User
Posts: 10,843

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

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

 

Occasional Contributor
Posts: 13

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

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;

Super User
Posts: 10,843

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

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;

Solution
‎10-17-2016 02:08 PM
Occasional Contributor
Posts: 13

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

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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