Hi @Jeff_DOC , base on your question and @Tom 's instruction, my solution is as follows. Please kindly let me if it answer your question @Jeff_DOC , many thanks!
data timeraw1;
input refdate mmddyy10. idnum
tripd mmddyy10. tript
returnd mmddyy10. returnt;
format refdate tripd returnd mmddyy10.
tript returnt time.;
datalines;
01/01/2018 636 7/11/2009 1416 7/11/2009 1950
02/01/2018 636 7/11/2009 1416 7/12/2009 1950
;
run;
proc print data=timeraw1;run;
data timediff;
set timeraw1;
tripdt=dhms(tripd,0,0,tript);
returndt=dhms(returnd,0,0,returnt);
diff=returndt-tripdt;
format tripdt returndt datetime19.
diff time12.;
run;
proc print data=timediff;run;
Hi @Tom ,thanks a lot for your question! Here is the further clarification: according to @Jeff_DOC 's description about the time variable, the values such as 1416 and 1950 may have two different meanings:
1) they are standard time values in numeric format (i.e., numbers that we see and use everyday), in this case, any of this kind of numbers can be converted to a standard time format such as 00:00 through apply the time. format to them; and just like what you already clearly described in your previous thread, @Tom , these numbers represent seconds (I did not pay attention to this knowledge before, because I just know that any number in a date/time column can be easily converted to standard date/time format and I did not worry about what they are exactly);
2) 1416 and 1950 means 14:16pm and 19:50pm, in this case, one can convert the number to a character format using cat(substr(put() )) function, and then convert the character time back to numeric time value and use it in calculating time difference.
Also, I think @Tom , your previous thread already well answered and clearly explained your question, and my solution is in accordance with yours (see the screen capture), thanks a lot for your questions, which makes me learnt more!
My answer:
And @Jeff_DOC , base on your question and @Tom 's instruction, if your time variable value 1416 and 1950 do represent 14:16 and 19:50, the solution is as follows. Please kindly let me know if it answer your question, @Jeff_DOC ,many thanks!
data timeraw2;
input refdate mmddyy10. idnum
tripd mmddyy10. tript
returnd mmddyy10. returnt;
format refdate tripd returnd mmddyy10.;
datalines;
01/01/2018 636 7/11/2009 1416 7/11/2009 1950
02/01/2018 636 7/11/2009 1416 7/12/2009 1950
;
run;
proc print data=timeraw2;run;
data timeraw2a;
set timeraw2;
tript1=cat(substr(put(tript,4.),1,2),
':',
substr(put(tript,4.),3,2)
);
returnt1=cat(substr(put(returnt,4.),1,2),
':',
substr(put(returnt,4.),3,2)
);
triptnum=input(tript1,time.);
returntnum=input(returnt1,time.);
run;
proc print data=timeraw2a;run;
data timediff2;
set timeraw2a;
tripdt=dhms(tripd,0,0,triptnum);
returndt=dhms(returnd,0,0,returntnum);
diff=returndt-tripdt;
format tripdt returndt datetime19.
diff time12.;
run;
proc print data=timediff2;run;
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.
-
994 views
-
4 likes
-
-
