Hi guys,
I have a data set called T1 as follows:
dt | User_Catg_ID |
01FEB15:18:34:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937 |
01FEB15:18:34:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937 |
01FEB15:18:34:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937 |
01FEB15:18:34:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937 |
01FEB15:18:34:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937 |
13MAR15:22:32:43 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524 |
13MAR15:22:32:43 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524 |
26FEB15:19:50:00 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:50:00 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:50:28 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:50:28 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:50:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:50:42 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:51:09 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
26FEB15:19:51:09 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808 |
01FEB15:17:05:38 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130 |
01FEB15:17:05:38 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130 |
19FEB15:20:44:24 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:44:24 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:44:24 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:44:24 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:48:52 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:53:25 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:53:25 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:53:25 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
19FEB15:20:53:25 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
02FEB15:19:55:51 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
03FEB15:18:54:50 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:18:38:19 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
01FEB15:18:38:19 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 |
I want to count the number of the session each person does. "dt" is the time that they visit the website and "User_Catg_ID" is their ID.
once they visit the website their session is one, if they are inactive for more than 30 min and again active, the session should be increased by 1.
for example :
dt | User_Catg_ID | Session |
18:30 | 555 | 1 |
18:31 | 555 | 1 |
18:35 | 555 | 1 |
19:45 | 555 | 2 |
19:47 | 555 | 2 |
20:02 | 985 | 1 |
20:03 | 985 | 1 |
20:05 | 985 | 1 |
I wrote the code but it does not work properly! could you please help me to fix this issue 😞
My code:
proc sort data=h.t1; by User_Catg_ID dt; run;
data h.t2;
set h.t1;
by User_Catg_ID;
retain session;
retain dt_r;
if first.User_Catg_ID=1 then session=1;
if first.User_Catg_ID=1 then dt_r = dt;
dt_diff = (dt-dt_r)/60;
if dt_diff > 30 then session+1=session;
else session=session;
dt_r = dt;
if last.User_Catg_ID=1 then user_last_pageview = 1;
drop dt_r dt_diff session;
run;
Like this?
data h.t2;
set h.t1;
by User_Catg_ID;
if first.User_Catg_ID=1 then session=1;
else if dif(dt)> 60*30 then session+1;
run;
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 | 1 |
01FEB15:17:16:16 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 | 1 |
01FEB15:18:38:19 | 4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533 | 2 |
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.