cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Hassankalantari
‎05-30-2018
  • 11 Posts
  • 1 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Need to count number of the session by using retain, (please help ...

by Fluorite | Level 6 in SAS Programming
‎05-30-2018 03:59 AM
‎05-30-2018 03:59 AM
Great! I dont have the data now, but I will try and let you know the result!! Thanks alot! ... View more

Re: Need to count number of the session by using retain, (please help ...

by Fluorite | Level 6 in SAS Programming
‎05-30-2018 02:04 AM
‎05-30-2018 02:04 AM
Hi Guys,    Thanks alot for the reply,  I  tried below code and it works, I also will use your codes! Thanks again 🙂   data h.Imp_Rev_x2; set h.Imp_Rev_x1; retain session; by User_Catg_ID; retain dt_r; if first.User_Catg_ID then session=1; if first.User_Catg_ID then dt_r = dt; dt_diff = (dt-dt_r)/60; if dt_diff > 30 then session=session+1; if dt_diff <= 30 then session=session; dt_r = dt; if last.User_Catg_ID=1 then user_last_pageview = 1; run;       ... View more

Need to count number of the session by using retain, (please help I al...

by Fluorite | Level 6 in SAS Programming
‎05-30-2018 12:02 AM
‎05-30-2018 12:02 AM
Hi guys,    I have a dataset called T1 its attached    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 : My code:I wrote the code but it does not work properly! could you please help me to fix this issue 😞   ... View more

Count number of a Session (Please help!)

by Fluorite | Level 6 in SAS Programming
‎05-29-2018 11:50 PM
‎05-29-2018 11:50 PM
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; ... View more

Re: Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-18-2018 06:58 PM
‎01-18-2018 06:58 PM
Hi Reeza,   Could you please help me with this one too,    How about if I want to find two words in a text! This time I want to find "Soundbar"! but some people write "Sound Bar". with an space between Sound and bar!   data Final_reviews1; set Final_reviews; SoundBar = index(upcase(ReviewText),'SOUNDBAR')>0; run;   Thanks in advance ... View more

Re: Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-11-2018 07:49 PM
‎01-11-2018 07:49 PM
It works!!!! Thanks alot! ... View more

Re: Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-11-2018 07:44 PM
‎01-11-2018 07:44 PM
Thank you so much for the reply! I will try your codes!     ... View more

Re: Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-11-2018 06:59 PM
‎01-11-2018 06:59 PM
Thanks!:) I will also try these! Hopefully it works for me!:) ... View more

Re: Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-11-2018 06:58 PM
‎01-11-2018 06:58 PM
Thank you so much for the reply! I forgot to mention that I have a data set called Final  and in the data set final I have many variable and one of them is reviewtext.      I will try the one that you send! Cheers H ... View more

Finding a word in Text!

by Fluorite | Level 6 in SAS Programming
‎01-11-2018 06:22 PM
‎01-11-2018 06:22 PM
Hi everyone!   Could you please help me with this matter!   I want to find a word within a text, if that word exist in the text, put 1 in a variable! for example,    Id                ReviewText                      Pillow       Duvet 1         The Pillows was comfortable          1             0                2          The stake was good                    0              0 3          Duvet and pillow was cheap       1               1   I used this code, but I keep receiving  "Variable ReviewTextt has been defined as both character and numeric" error!     data Final; set Final1(rename=(ReviewText=ReviewTextT)); ReviewText = put(ReviewTextT, 9999.); drop ReviewTextT; run; Data Final; length ReviewText $ 9999; data final0; Word = scan (ReviewText,1,'*'); if word in ('pillow' 'pillows') then Pillow=1; set final; run;   Thanks in advance for helping! H ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-30-2018 04:30 AM
Likes given to
View All
Quick links