Informat to read the SAS time for input value 21:43

[Nikhilvg]

data sasprg.data1;
infile datalines delimiter=" ";
input Bday $ Date date11. Timer stimer5. Country $ Gender $;
format Date date11. Timer time5.;
datalines;
29SEP2018 29-Aug-19 10:36 ARGENTINA Male;

run;

Output:

Obs Bday Date Timer Country Gender1

29SEP201

29-AUG-2019

0:00

ARGENTIN

Male

Please advise to get an value of timer variable in output table as 10:36

[Tom · Accepted solution]

Why are you reading 11 character for the date value when it only has 9?

Try using LIST mode input instead of FORMATTED mode.  Also make sure you include at least one line of data.  The datalines stop on the last line BEFORE the semi-colon.  Also no need to include an extra RUN statement after the end of your data step.

data sasprg.data1;
  infile datalines ;
  input Bday :$9. Date :date. Timer :stimer. Country :$30. Gender :$7.;
  format Date date11. Timer time5.;
datalines;
29SEP2018 29-Aug-19 10:36 ARGENTINA Male
;

[Ksharp]

data data1;
infile datalines delimiter=" ";
input Bday : $20. Date : date11. Timer : time. Country $ Gender $;
format Date date9. Timer time5.;
datalines;
29SEP2018 29-Aug-19 10:36 ARGENTINA Male
;
run;