Hi All, I have a time variable in the format of datetime32.4(ex: 21MAR2019:10:19:15.2970) and I'm trying to group the time into the following block such as showing in the SAS code:     proc format; value timerng "06:00"t -< "15:59"t= "6:00am - 3:59pm" "16:00"t -< "21:59"t = "4:00pm - 9:59pm" "22:00"t -< "05:59"t = "10:00pm - 5:59am"; run; I received an error message saying the start is greater than the end. Is there any other way to group the time variable into the wanted blocks?   Thank you! ... View more

Hi All,   I have a similar structure of dataset as of the following:   Session       Code 1                   7.1 1                   10.1 1                   10.2 1                   10.3 2                   10.2 2                   10.3 3                   10.2 3                   10.3 4                   7.1   I'm trying to extract cases by session. The condition is that if a session contains code 7.1 then the session is removed, and we only keep the sessions with code 10.2 or 10.3, but these sessions must not contain code 7.1.   The desired output should be:   Session       Code 2                   10.2 2                   10.3 3                   10.2 3                   10.3   My current code below for some reason does not remove session 1: data have; input session$ code$; cards; 1 7.1 1 10.1 1 10.2 1 10.3 2 10.2 2 10.3 3 10.2 3 10.3 4 7.1 ; run; proc sql; create table want as select session, code from have group by session having code ne "7.1" and (code = "10.2" or code = "10.3"); quit;   ... View more

Hi All,   I have a time variable that is in the format of timeampm11. ex:12:48:06 AM   How do I extract the "AM" from the time value? I have tried the following code none of them worked:   if index(timestamp, 'AM') then td = "AM"; if scan(timestamp,3," ") eq "AM" then td = "AM"; Thank you!   ... View more

I have a very simple merge, but no matter what I do I cannot get to the desired outcome.   Dataset A:   session grp device 1 2 mac 2 4 desk Dataset B   session grp 1 2 1 2 2 4 2 4 2 4     Try to get:   session grp device 1 2 mac 1 2 mac 2 4 desk 2 4 desk 2 4 desk   I have tried left merge on B with A by proc sql and datastep, and the normal merge. proc sql; create table want as select L.*, R.* from datasetB as L left join datasetA as R on L.session = R.session and L.grp = R.grp; quit; data want; length device_type $10.; merge datasetB (in=a) datasetA (in=b); by session grp; run; data want; length device_type $10.; merge datasetB (in=a) datasetA (in=b); by session grp; if a; run; I always get the following result (device does not repeat):   session grp device 1 2 mac 1 2 2 4 desk 2 4 2 4   There are other variables in the dataset B, I'm just using the 3 major ones used in merge as an example. Eventually the final dataset will have more than 3 variables.   Thank you! ... View more

Hi All,   I have a dataset that carries missing by terms containing _LOAD_TIME, LANG_ENTRY_TIME, LANG_EXIT_TIME and CLOSE_BROWSER_TIME. The flag variable is created from the X value extracted from DASHBOARD_X_START_TIME. This can be achieved by using:   flag = strip(compress(strip(name),,'kd'));   Which I have done so already. Now I need to populate the missing cells by using the later created none-missing flag value, and I wish to maintain the original order.   The dataset with missings:     Name Flag DASHBOARD_LOAD_TIME   DASHBOARD_LANG_ENTRY_IND   DASHBOARD_1_START_TIME 1 DASHBOARD_LANG_EXT_IND   DASHBOARD_CLOSE_BROWSER_TIME   DASHBOARD_LOAD_TIME   DASHBOARD_LANG_ENTRY_IND   DASHBOARD_2_START_TIME 2 DASHBOARD_LANG_EXT_IND   DASHBOARD_CLOSE_BROWSER_TIME   DASHBOARD_LOAD_TIME   DASHBOARD_LANG_ENTRY_IND   DASHBOARD_3_START_TIME 3 DASHBOARD_LANG_EXT_IND   DASHBOARD_CLOSE_BROWSER_TIME       The desired outcome:   Name Flag DASHBOARD_LOAD_TIME 1 DASHBOARD_LANG_ENTRY_IND 1 DASHBOARD_1_START_TIME 1 DASHBOARD_LANG_EXT_IND 1 DASHBOARD_CLOSE_BROWSER_TIME 1 DASHBOARD_LOAD_TIME 2 DASHBOARD_LANG_ENTRY_IND 2 DASHBOARD_2_START_TIME 2 DASHBOARD_LANG_EXT_IND 2 DASHBOARD_CLOSE_BROWSER_TIME 2 DASHBOARD_LOAD_TIME 3 DASHBOARD_LANG_ENTRY_IND 3 DASHBOARD_3_START_TIME 3 DASHBOARD_LANG_EXT_IND 3 DASHBOARD_CLOSE_BROWSER_TIME 3   Thank you for any inputs! ... View more

Hi All,   I'm merging very large datasets that have many variables. Is there an efficient way to find the variable with the most unique values for merging? Assuming there are still duplicates, I'm just trying to find the most unique value to prevent the merged dataset to be too large. I'm thinking maybe a program that prints out counts of unique values for each variable will be helpful so that I can compare and pick the variable with the most unique count.    Thank you! ... View more