topic Re: calculate day hours into hours in sas in SAS Programming

calculate day hours into hours in sas

sophielr — Tue, 06 Jun 2023 16:57:49 GMT

Hi, thank you for any help. I need to convert character day and hour into hours

data one;
input day $1-13;
cards;
04days,5 hours

15days, 06 Hours
;
run;

what I want result is

101 hours

366 hours

Re: calculate day hours into hours in sas

PaigeMiller — Tue, 06 Jun 2023 17:11:28 GMT

First you get rid of the alphabetic characters and spaces, leaving just the numbers and a comma, via the COMPRESS command. The first number is the days, you convert it to numeric via the INPUT command. The second number is the hours, you convert it to numeric via the INPUT command. Lastly, you compute total hours, which I leave to you as a homework assignment.

data one;
input day $1-16;
cards;
04days,5 hours
15days, 06 Hours
;

data want;
    set one;
    day=compress(day,' ','a');
    hours=input(scan(day,2,','),2.);
    days=input(scan(day,1,','),2.);
run;

Re: calculate day hours into hours in sas

Seadrago — Tue, 06 Jun 2023 17:20:58 GMT

data ds1;
set one;

/*seperate days and hours into 2 variables and convert to numeric*/

days=input(scan(day, 1, "days,"), best.);

hours=input(scan(scan(day, 2, "days,"), 1, " "), best.);

/*derive total hours using numeric variables*/

tothours=(days*24)+hours;

run;