Yes. There are many ways in SAS can solve the same question.
data have;
input App ModifiedTime anydtdtm32.;
date=datepart(modifiedtime);
format modifiedtime datetime. date date9.;
cards;
001 09/07/16 11:03:08
001 09/08/16 12:26:15
001 09/08/16 11:04:52
001 09/12/16 09:05:10
002 09/01/16 11:03:08
002 09/02/16 12:26:15
002 09/04/16 11:04:52
002 09/09/16 09:05:10
;
run;
data want;
merge have have(keep=app date rename=(app=_app date=_date) firstobs=2);
output;
if app=_app then do;
do i=date+1 to _date-1;
modifiedtime=dhms(i,1,1,1);output;
end;
end;
drop _: i date;
run;
... View more