topic Converting Days into Hours in SAS Procedures

Converting Days into Hours

Lien728 — Wed, 18 Apr 2012 19:55:58 GMT

How do I convert a variable that has data given in number of days, to have an output with number of hours?

Example:

Variable Name- Length_of_stay

datalines;

1.5

2

1

0.5

6

;

Thanks!

Re: Converting Days into Hours

ballardw — Wed, 18 Apr 2012 20:03:33 GMT

Assuming length_of_stay represents days then the short answer would be

Length_of_stay_hours = Length_of_stay *24;

However if your application has to consider the fraction time that yields leap days and such we get into more complex intervals.

Re: Converting Days into Hours

Lien728 — Wed, 18 Apr 2012 20:50:11 GMT

That works perfectly!

However, the only problem I am having, is that it sets my first observation to missing (represented by a '.'), and then starts at the beginning for the second observation.

This is what I mean,

datalines;

1.5

2

1

0.5

6

;

Output reads:

.

36

48

24

12

How do I fix this?

Re: Converting Days into Hours

Lien728 — Wed, 18 Apr 2012 21:00:22 GMT

Nevermind, I figured it out and it was all about placement.

I had to place Length_of_stay_hours= Length_of_stay*24; right after my set statement.

Thanks a ton!