topic Re: reading time varialble error in SAS Programming

reading time varialble error

BrahmanandaRao — Sun, 23 Feb 2020 08:22:08 GMT

data retail;
input id date date9. time hh:mm:ss;
format date date9. time hh:mm:ss ;
datalines;
1 18Jun2018 13:25:21
2 28Jun2018 11:33:21
3 29Jun2018 11:24:21
4 29Jun2018 13:25:45
6 21Jun2018 9:59:05
;
run;

Time reading variable error

Re: reading time varialble error

Kurt_Bremser — Sun, 23 Feb 2020 08:29:32 GMT

Once again, Maxim 1: Read the Documentation!!

hh:mm:ss is not a valid informat, in fact it is not even a valid SAS name.

Re: reading time varialble error

Kurt_Bremser — Sun, 23 Feb 2020 08:31:00 GMT

And also read up the documentation for the input statement, list input; and how to use formats in list input.

Re: reading time varialble error

ed_sas_member — Sun, 23 Feb 2020 09:33:29 GMT

Hi @BrahmanandaRao

As mentioned by @Kurt_Bremser, this is not a valide format.

You can use ":informat." in the input statement to specify how to interpret input values, and then specify the format for display :

data retail;
input id date:date9. time:time8.;
format date date9. time time8. ;
datalines;
1 18Jun2018 13:25:21
2 28Jun2018 11:33:21
3 29Jun2018 11:24:21
4 29Jun2018 13:25:45
6 21Jun2018 9:59:05
;
run;

-> You can see that SAS reads correctly the date and the time variables.