Hi All, I'm hoping to determine user activity by how often they switch from one screen to another. I have the known columns Name, Activity, Screen, Value and is having trouble code for Switch:   Name Activity Screen Value Switch Mary Home_test_entry Home 2 No Mary Home_test_exist Home 2 No Mary Landing_test_entry Landing 1 One_Two Mary Login_test_entry Login 1 Switch_within Mary Login_test_entry Login 2 Switch_within Mary Login_test_exit Login 1 Switch_within Mary Login_test_exit Login 2 Switch_within Mary Login_test_time Login 08:09:12 Switch_time Mary Candy_test_entry Candy 2 No Mary Candy_test_exit Candy 2 No Tom Home_test_entry Home 2 Switch_within Tom Home_test_exist Home 1 Switch_within Tom Landing_test_entry Landing 2 Two_One Tom Landing_test_exit Landing 1 Two_One   Condition for Switch: After sorting, Activity "Landing_test_entry" is not always followed by "Landing_test_exit"   on screen "Landing", thus switch is determined by any screen visited by the same user with activity followed by "text_exit". If "xxx_text_exit", xxx = screen, value = 2 and "Landing_test_entry" = 1, then switch = one_two, and vice versa, switch = two_one. For any other screen visited by that user, if value does not change within a screen, then Switch = No, else Switch = Switch_within. If value equal a time value, then Switch = switch_time. An user can visit many possible screens, the table is only a briefed version of the actual dataset.   Thank you!   Following is my attempted code:   proc sort data=have; by name activity; run; data want; set have; length pre_name $62. pre_value $250. switch $10.; by name activity; retain pre_activity pre_value; if first.name then do; pre_activity = ""; pre_value = ""; pre_screen = ""; end; pre_activity= lag(activity); pre_value = lag(value); pre_screen = lag(screen); if activity = "Landing_test_entry" and value = "1" then do; /*do not know how to code "Landing_test_exit" as the following item */ activity = "Landing_test_exit" and value = "2" then do; Switch = "One_Two"; retain pre_screen; if screen_name = pre_screen then switch = "One_Two"; ...... run;     ... View more

Hi All,   I have a time variable that contains the values in the form of : 2018-04-20T20:38:12.124Z I tried to convert it into sas date time with the following code:   value_year = input(substr(value,1,4), 4.); value_month = input(substr(value,6,2), 2.); value_day = input(substr(value,9,2), 2.); date = MDY(value_month,value_day, value_year); value_hour = input(substr(value,12,2), 2.); value_minute = input(substr(value,15,2), 2.); value_second = input(substr(value,18,6), 6.3); sasdatetime = DHMS(date,value_hour,value_minute, value_second); Now I'm hoping to calculate the difference between two time values after converting the original values to the form of "sasdatetime". The unit of the difference should be in minute and second (MM/SS).   For example the time interval between: 2018-03-23T14:19:43.046Z and 2018-03-28T02:56:37.460Z   In minute and second.   Thank you!   ... View more

Hi All,   I have a dataset with duplicates and I'm trying to study duplicated records, the dataset is shaped as of the following, and I'm trying to create a dup variable.    The dup count will be grouped by session_id, device_name and time, and it will have repeated numbers if the defined group are identical within session_id.   session_id device_name time dup 1 desktop 12 1 1 desktop 12 1 1 desktop 12 1 1 tablet 10 2 2 tablet 11 1 2 tablet 11 1 2 mobile 10 2 2 desktop 10 3 3 desktop 10 1 3 desktop 10 1    Appreciate for any help.  ... View more