https://communities.sas.com/t5/SAS-Programming/Count-number-of-a-Session-Please-help/m-p/465888#M118842 <P>Hi guys,&nbsp;</P><P>&nbsp;</P><P>I have a data set called T1 as follows:</P><TABLE><TBODY><TR><TD>dt</TD><TD><SPAN>User_Catg_ID</SPAN></TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>13MAR15:22:32:43</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524</TD></TR><TR><TD>13MAR15:22:32:43</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524</TD></TR><TR><TD>26FEB15:19:50:00</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:00</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:28</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:28</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:51:09</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:51:09</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>01FEB15:17:05:38</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130</TD></TR><TR><TD>01FEB15:17:05:38</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:18:38:19</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:18:38:19</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>I want to count the number of the session each person does. "dt" is the time that they visit the website and "<SPAN>User_Catg_ID"&nbsp;</SPAN>is their ID.&nbsp;&nbsp;</P><P>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.&nbsp;</P><P>for example :</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>dt</TD><TD><SPAN>User_Catg_ID</SPAN></TD><TD>Session</TD></TR><TR><TD>18:30</TD><TD>555</TD><TD>1</TD></TR><TR><TD>18:31</TD><TD>555</TD><TD>1</TD></TR><TR><TD>18:35</TD><TD>555</TD><TD>1</TD></TR><TR><TD>19:45</TD><TD>555</TD><TD>2</TD></TR><TR><TD>19:47</TD><TD>555</TD><TD>2</TD></TR><TR><TD>20:02</TD><TD>985</TD><TD>1</TD></TR><TR><TD>20:03</TD><TD>985</TD><TD>1</TD></TR><TR><TD>20:05</TD><TD>985</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I wrote the code but it does not work properly! could you please help me to fix this issue <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>My code:</P><P>&nbsp;</P><P>proc sort data=h.t1; by <SPAN>User_Catg_ID&nbsp;</SPAN>dt; run;<BR />data h.t2;<BR />set h.t1;<BR />by User_Catg_ID;<BR />retain session;<BR />retain dt_r;<BR />if first.User_Catg_ID=1 then session=1;<BR />if first.User_Catg_ID=1 then dt_r = dt;<BR />dt_diff = (dt-dt_r)/60;<BR />if dt_diff &gt; 30 then session+1=session;<BR />else session=session;<BR />dt_r = dt;<BR />if last.User_Catg_ID=1 then user_last_pageview = 1;</P><P>drop dt_r dt_diff session;<BR />run;</P> Wed, 30 May 2018 03:50:01 GMT Hassankalantari 2018-05-30T03:50:01Z https://communities.sas.com/t5/SAS-Programming/Count-number-of-a-Session-Please-help/m-p/465888#M118842 <P>Hi guys,&nbsp;</P><P>&nbsp;</P><P>I have a data set called T1 as follows:</P><TABLE><TBODY><TR><TD>dt</TD><TD><SPAN>User_Catg_ID</SPAN></TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>01FEB15:18:34:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33008937</TD></TR><TR><TD>13MAR15:22:32:43</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524</TD></TR><TR><TD>13MAR15:22:32:43</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33011524</TD></TR><TR><TD>26FEB15:19:50:00</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:00</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:28</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:28</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:50:42</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:51:09</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>26FEB15:19:51:09</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33012808</TD></TR><TR><TD>01FEB15:17:05:38</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130</TD></TR><TR><TD>01FEB15:17:05:38</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33013130</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:44:24</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:48:52</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>19FEB15:20:53:25</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33017029</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>02FEB15:19:55:51</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>03FEB15:18:54:50</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 33024975</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:17:16:16</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:18:38:19</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR><TR><TD>01FEB15:18:38:19</TD><TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>I want to count the number of the session each person does. "dt" is the time that they visit the website and "<SPAN>User_Catg_ID"&nbsp;</SPAN>is their ID.&nbsp;&nbsp;</P><P>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.&nbsp;</P><P>for example :</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>dt</TD><TD><SPAN>User_Catg_ID</SPAN></TD><TD>Session</TD></TR><TR><TD>18:30</TD><TD>555</TD><TD>1</TD></TR><TR><TD>18:31</TD><TD>555</TD><TD>1</TD></TR><TR><TD>18:35</TD><TD>555</TD><TD>1</TD></TR><TR><TD>19:45</TD><TD>555</TD><TD>2</TD></TR><TR><TD>19:47</TD><TD>555</TD><TD>2</TD></TR><TR><TD>20:02</TD><TD>985</TD><TD>1</TD></TR><TR><TD>20:03</TD><TD>985</TD><TD>1</TD></TR><TR><TD>20:05</TD><TD>985</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I wrote the code but it does not work properly! could you please help me to fix this issue <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>My code:</P><P>&nbsp;</P><P>proc sort data=h.t1; by <SPAN>User_Catg_ID&nbsp;</SPAN>dt; run;<BR />data h.t2;<BR />set h.t1;<BR />by User_Catg_ID;<BR />retain session;<BR />retain dt_r;<BR />if first.User_Catg_ID=1 then session=1;<BR />if first.User_Catg_ID=1 then dt_r = dt;<BR />dt_diff = (dt-dt_r)/60;<BR />if dt_diff &gt; 30 then session+1=session;<BR />else session=session;<BR />dt_r = dt;<BR />if last.User_Catg_ID=1 then user_last_pageview = 1;</P><P>drop dt_r dt_diff session;<BR />run;</P> Wed, 30 May 2018 03:50:01 GMT https://communities.sas.com/t5/SAS-Programming/Count-number-of-a-Session-Please-help/m-p/465888#M118842 Hassankalantari 2018-05-30T03:50:01Z https://communities.sas.com/t5/SAS-Programming/Count-number-of-a-Session-Please-help/m-p/466324#M118977 <P>Like this?</P> <PRE><CODE class=" language-sas">data h.t2; set h.t1; by User_Catg_ID; if first.User_Catg_ID=1 then session=1; else if dif(dt)&gt; 60*30 then session+1; run;</CODE></PRE> <TABLE width="592"> <TBODY> <TR> <TD width="112">01FEB15:17:16:16</TD> <TD width="416">4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD> <TD width="64">1</TD> </TR> <TR> <TD>01FEB15:17:16:16</TD> <TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD> <TD>1</TD> </TR> <TR> <TD>01FEB15:18:38:19</TD> <TD>4ecd9ffb-8661-4e0a-aa0b-529689a4a90b 34955533</TD> <TD>2</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 31 May 2018 06:00:56 GMT https://communities.sas.com/t5/SAS-Programming/Count-number-of-a-Session-Please-help/m-p/466324#M118977 ChrisNZ 2018-05-31T06:00:56Z