topic Re: Input function, informat and format in New SAS User

Input function, informat and format

cx2019 — Sun, 07 Apr 2019 12:20:13 GMT

There is a variable ttime in character form in table A, which represents the transaction time. The content is as follows:
09-05-21
10-56-34
15-23-47

The digits separated are respectively hours, minutes, and seconds.

(1) Write the data stepthat converts ttime to a time variable.
(2)To see the value of the ttime in time format, write the format statement.

Re: Input function, informat and format

PaigeMiller — Sun, 07 Apr 2019 13:15:19 GMT

Please show us the code that you have tried.

Re: Input function, informat and format

PeterClemmensen — Sun, 07 Apr 2019 14:21:09 GMT

data have;
input ttime $8.;
datalines;
09-05-21
10-56-34
15-23-47
;

data want;
   set have;
   ttime_num=input(ttime, time8.);
   format ttime_num time8.;
run;

Re: Input function, informat and format

singhsahab — Sun, 07 Apr 2019 14:33:08 GMT

Hello,

data want (keep=time_var);
input ttime $;
time_var=input(ttime,time9.);
format time_var time9.;
datalines;
09-05-21
10-56-34
15-23-47
;
run;

or 


data want (keep=time_var);
input ttime $;
new_var_time=tranwrd(ttime,'-',":");
time_var=input(new_var_time,time9.);
format time_var time9.;
datalines;
09-05-21
10-56-34
15-23-47
;
run;