topic Re: Array to group time variable in SAS Programming

Array to group time variable

fordcr2 — Tue, 19 Nov 2019 18:42:42 GMT

Hello,

I am trying to re-categorize a time variable so that I can query how many the frequency of use of a medical device for each hour of the day.

I am trying to figure out how to put the following code in an array format so that I do not have to type this out 24 times (for each of the 24 hours of the day), but I am still pretty new to using arrays so I have not been able to figure it out.

data v2; set v1;

select;
when ("00:00:00"t <= start_time < "1:00:00"t) hour=1;
when ("01:00:00"t <= start_time< "2:00:00"t) hour=2;
/*[... etc until hour=24]*/
end;

run;

Is there an easier way to do this?

Re: Array to group time variable

Reeza — Tue, 19 Nov 2019 18:57:22 GMT

I suspect you're trying to scaffold a data set, ie see how many people are active at each hour of the day given the start and end time? If so, yes, there are easier ways. If you post some example data and expected output someone can help you further with this issue.

Feel free to make up data if needed.

Re: Array to group time variable

PaigeMiller — Tue, 19 Nov 2019 18:59:53 GMT

No arrays needed here.

Use the HOUR. format, and so the time of 08:43 will be converted to 8 and the time of 19:07 will be converted to 19 and so on. Almost every SAS analysis procedure will work with the formatted value rather than the original unformatted value.

Another thought is to simply take the time and using mathematics, turn it into an integer. Since time is measured in seconds after midnight, this code will do what you wan

newtime=floor(time/3600);

Re: Array to group time variable

fordcr2 — Tue, 19 Nov 2019 19:01:48 GMT

That works - thanks!

Re: Array to group time variable

Tom — Tue, 19 Nov 2019 19:24:02 GMT

No need to use "magic" numbers in the code. You can use a time literal to figure how many seconds are in an hour.

newtime=floor(time/'01:00't);