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!
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.
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.
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?
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!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.