Help using Base SAS procedures

Converting Days into Hours

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Converting Days into Hours


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!


Accepted Solutions
Solution
‎04-18-2012 04:03 PM
Super User
Posts: 10,483

Re: Converting Days into Hours

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.

View solution in original post


All Replies
Solution
‎04-18-2012 04:03 PM
Super User
Posts: 10,483

Re: Converting Days into Hours

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.

Occasional Contributor
Posts: 10

Re: Converting Days into Hours


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?

Occasional Contributor
Posts: 10

Re: Converting Days into Hours

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!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 225 views
  • 0 likes
  • 2 in conversation