Reading Datetime and Timezone value as Character

atinytale — Thu, 15 Dec 2022 16:53:40 GMT

Hello everyone,

I'm facing an issue with reading datetime and timezone value into SAS as a character.

data a;
input abc : $100.;
informat abc $100.;
format abc $100.;
cards;
2023-11-11 11:06:35.140028 America/New_York
;
run;

When I execute the above, SAS is not reading the entire value. It is just reading the date. Could anyone please help.

Thanks so much.

Re: Reading Datetime and Timezone value as Character

Tom — Thu, 15 Dec 2022 17:02:19 GMT

Because you told it to use LIST MODE input by using the colon modifier in the INPUT statement it stopped at the first delimiter character, space. Use FORMATTED MODE input. But you might want to add an INFILE statement so you can add the TRUNCOVER option since data lines are a always a multiple of 80 bytes long.

Note there is no need to attach either an informat or a format to that variable. SAS does not need to be given special instructions for how to read or write normal strings.

data a;
  infile cards truncover;
  input abc $100.;
cards;
2023-11-11 11:06:35.140028 America/New_York
;

topic Reading Datetime and Timezone value as Character in SAS Programming

Reading Datetime and Timezone value as Character

Re: Reading Datetime and Timezone value as Character