topic Time in SAS Programming

Time

Sowmya12 — Mon, 17 May 2021 12:02:01 GMT

Suppose if the values are 0900 and 0930 I need the output as 09:00 and 09:30
Suggest me a solution

Re: Time

PaigeMiller — Mon, 17 May 2021 12:16:17 GMT

Could you provide more information? Is the variable that contains 0900 and 0930 numeric or character? (I'm guessing character)

Does 0900 represent 9 minutes and zero seconds, or is it 9 hours and 0 minutes?

Re: Time

ballardw — Mon, 17 May 2021 12:20:07 GMT

What do you have now? Is that "0900" a character value? A number? What is the name of the variable?

If character you create a new variable that holds a SAS time value and assign a format: One way:

data example;
  x='0900';
  numval = input(x,f4.);
  timevalue = hms(int(numval/100), mod(numval,100),0);
  format timevalue time5.;
run;

The function hms needs a numeric hour, minute and second value. Since you don't have any seconds shown then that uses 0.

If your current variable is numeric then skip the step that creates Numval.

The format shows values in HH:MM format.

You could drop Numval from the data.

If your variable is a number you could use the name in both the places numval appears in the HMS function and the Timevalue variable.

Re: Time

Sowmya12 — Mon, 17 May 2021 12:22:06 GMT

Numeric

Re: Time

PaigeMiller — Mon, 17 May 2021 12:26:23 GMT

Numeric variables don't have leading zeros unless they are formatted. Can you please run PROC CONTENTS and confirm this variable is numeric, and tell us what the format is?

You didn't answer my other question:

"Does 0900 represent 9 minutes and zero seconds, or is it 9 hours and 0 minutes?"

Re: Time

Sowmya12 — Thu, 17 Jun 2021 05:17:54 GMT

Hii

Id time$
1 0900
2 0930
3 0825

The time variable is in character and the output should be in time5.
Format.

Thanks
Sowmya

Re: Time

andreas_lds — Thu, 17 Jun 2021 06:29:27 GMT

@Sowmya12 wrote:
Hii

Id time$
1 0900
2 0930
3 0825

The time variable is in character and the output should be in time5.
Format.

Thanks
Sowmya

Untested:

data want;
  set have;
  length time 8 helper $ 5;
  format time time5.;
  helper = cats(substr(timeStr, 1, 2), ':', substr(timeStr, 3, 2));
  time = input(helper, time.);
run;