## Converting Days into Hours

Solved
Occasional Contributor
Posts: 10

# 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: 13,583

## 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.

All Replies
Solution
‎04-18-2012 04:03 PM
Super User
Posts: 13,583

## 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 and locked.

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

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