topic Re: How to read 24 hrs time format in New SAS User

How to read 24 hrs time format

BrahmanandaRao — Fri, 31 May 2019 04:21:41 GMT

HI Experts i unable to read below dataset using dateampm

data trians;
input train_name $ 1-22  arrival 23-26  dept 27-32  total_hours 34-39;
informat arrival dateampm dept dateampm total_hours dateampm;
format arrival dateampm dept dateampm total_hours dateampm		;
datalines;
VSKP GARIB RATH(12740)  20:30 04:06 07:36	
GODAVARI EXP(12728)  7:40 01:39 07:59
FALAKNUMA EXP(12704) 15:55 00:02 08:07
;
run;

Re: How to read 24 hrs time format

Patrick — Fri, 31 May 2019 06:26:21 GMT

There are a few other issues with your code but here how you can read your time strings.

data trains;
  informat arrival dept total_hours time5.;
  format arrival dept total_hours time5.;
  input arrival dept total_hours ;
  datalines;
20:30 04:06 07:36 
;
run;

proc print data=trains;
run;

Re: How to read 24 hrs time format

BrahmanandaRao — Fri, 31 May 2019 06:34:47 GMT

Thank you for response

But i want output train name including train code

Regards,

Anand

Re: How to read 24 hrs time format

Patrick — Fri, 31 May 2019 06:49:54 GMT

@BrahmanandaRao

I've answered your question on how to read the time strings.

To make everything work: You're posting an input statement which uses list input but the data you post is not on the positions where it should be according to what you've coded. So what's correct now? The data layout or your input statement?

Why don't you give it a go first on your own and then ask more targeted questions when you get stuck.