Dear All,
I have to find the difference between the two times in character format. Can some one help me on these...
09:15 17:40----Have to find difference between these two.Ideally i would like to conver numeric sas format and then do the subtraction.
09:40 16:50----Have to find difference between these two
Thanks in advance.
Rakesh
data test;
format time1 time2 diff time8.;
time1 = input('09:15',time5.);
time2 = input('17:40',time5.);
diff = time2 - time1;
output;
time1 = input('09:40',time5.);
time2 = input('16:50',time5.);
diff = time2 - time1;
output;
run;
proc print data=test noobs;
run;
Result:
time1 time2 diff 9:15:00 17:40:00 8:25:00 9:40:00 16:50:00 7:10:00
data test;
format time1 time2 diff time8.;
time1 = input('09:15',time5.);
time2 = input('17:40',time5.);
diff = time2 - time1;
output;
time1 = input('09:40',time5.);
time2 = input('16:50',time5.);
diff = time2 - time1;
output;
run;
proc print data=test noobs;
run;
Result:
time1 time2 diff 9:15:00 17:40:00 8:25:00 9:40:00 16:50:00 7:10:00
Thank you Sir..
Are the pairs in one or separate strings?
Art, CEO, AnalystFinder.com
convert char time as var="09:15" using time_1 = input(var,time5.);
to calculate the difference just do: diff = intck('minute',time_1,time_2);
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.