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
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;
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.