@mkeintz wrote:
@ballardw :
You don't need to extract date values from datetimes to generate number of days (i.e. number of midnights crossed) between two datetimes
data want;
set temp;
by user_id;
interval=intck('hour24',lag(date),date);
if first.id then interval=.;
run;
regards,
Mark
Or use 'DTDAY' I believe.
... View more
