topic Re: reading datetime value in SAS Programming

reading datetime value

Aexor — Sun, 23 Aug 2020 14:04:00 GMT

I am trying to read date time column in my code. please find code below

data check;
input name $5. id 3. date datetime20. ;
FORMAT DATE DATETIME20. ;

DATALINES;
ROHAN 123 11AUG2020:19:17:20
MOHAN 123 11AUG2020:20:15:20
SOHAN 123 13AUG2020:00:17:20
KOHAN 123 15AUG2020:19:17:20
;
RUN;
I am getting missing value in particular date coloumn and even the id value is not being read properly 
I am getting only first two didgit.

Re: reading datetime value

novinosrin — Sun, 23 Aug 2020 14:13:45 GMT

data check;
input name $5. id :3. date :datetime20. ;
FORMAT DATE DATETIME20. ;

DATALINES;
ROHAN 123 11AUG2020:19:17:20
MOHAN 123 11AUG2020:20:15:20
SOHAN 123 13AUG2020:00:17:20
KOHAN 123 15AUG2020:19:17:20
;
RUN;

Basically the idea is to read conveniently as a "modified list input" as opposed to using a in-formatted input.

Re: reading datetime value

Kurt_Bremser — Sun, 23 Aug 2020 14:12:27 GMT

Use the colon modifier in your INPUT statement, or it will not honor the delimiters:

input name :$5. id :3. date :datetime20.;

Re: reading datetime value

Tom — Sun, 23 Aug 2020 14:17:15 GMT

You told the INPUT statement to read a fixed number of bytes for each variable. Just count the columns to see why it is not working.

----+---10----+---20----+---30
ROHAN 123 11AUG2020:19:17:20
MOHAN 123 11AUG2020:20:15:20
SOHAN 123 13AUG2020:00:17:20
KOHAN 123 15AUG2020:19:17:20

If the values are really always in fixed columns then adjust your INPUT statement to read from the right columns.

input @1 name $5. @7 id 3. @11 date datetime20. ;

Of if you know every line has three and only three space separated values and none of the values have embedded spaces then switch to list mode input instead of formatted mode.

input name :$5. id date :datetime20. ;

Re: reading datetime value

Aexor — Sun, 23 Aug 2020 14:24:56 GMT

Thanks 🙂