topic Convert character hours and minutes to numeric days in SAS Programming

Convert character hours and minutes to numeric days

stancemcgraw — Fri, 02 Oct 2020 19:05:45 GMT

Hi all,

My hospital length of stays were in excel as '55:02:00' which are in hours and there must have previously been some character code in the column, because when I imported to SAS it changed to $31. and looks like '2.293055555555555556' except it's now in character. Any ideas how to convert it this into days (numeric?) and round up or down from the 10ths place.

Data have;

HLOS

55:02:00

203:46:00

192:42:00

data want;

HLOS (days)

Re: Convert character hours and minutes to numeric days

Reeza — Fri, 02 Oct 2020 19:28:12 GMT

How did you import your data? Can you fix it in that step?

Re: Convert character hours and minutes to numeric days

PaigeMiller — Fri, 02 Oct 2020 19:28:55 GMT

Since you already have the values as '2.293055555555555556', just take this character string and convert it into days

days=input(hlos,7.0);

If you want to round off, instead of truncate (which is what the above code will do), then you can modify the code properly.

Re: Convert character hours and minutes to numeric days

mklangley — Fri, 02 Oct 2020 19:41:00 GMT

@stancemcgraw Since you already have the number of days in character strings, give this a try.

data have;
    input hlos $31.;
    datalines;
    2.293055555555555556
    8.490277777777777
    8.0291667
;
run;

data want;
    set have;
    hlos_numeric = round(input(hlos, 12.4), 1);
run;

(Also, I believe your second example would round off to 8 days, not 9.)