Hello,   I have 2 datasets and I would like to create 3rd dataset    Dataset #1   patientID date volume 4444 1/2/2014 45 4444 1/3/2014 50 4444 1/4/2014 12 4444 1/5/2014 33 4444 1/6/2014 12 3233 1/6/2015 66 3233 1/7/2015 35 3233 1/9/2015 23   Dataset #2 patientID date flag 4444 1/4/2014 1 3233 1/7/2015 1   Want dataset #3 patientID date volume flag 4444 1/2/2014 45   4444 1/3/2014 50   4444 1/4/2014 12 1 4444 1/5/2014 33   4444 1/6/2014 12   3233 1/6/2015 66   3233 1/7/2015 35 1 3233 1/9/2015 23     I tried the following PROC SQL; SELECT bb.*, cc.flag FROM a.dataset_1 bb LEFT JOIN a.dataset_2 cc on bb.patientID = cc.patientID; QUIT;   But it doesn't work or shows "flag = 1" for all the records. I also tried full outer join etc.  Thanks ... View more

Hello, I need help merging the dates that do not match for 2 different datasets   Dataset #1: Screening   Group Screen_date Total_screen A 1/1/2018 1 A 2/1/2018 2 A 3/1/2018 2 A 5/1/2018 3   Dataset #2: Randomizaiton Group rand_date Total_rand A 1/1/2018 1 A 2/1/2018 2 A 4/1/2018 2 A 5/1/2018 1   Want:  Group New_date Total_screen Total_random A 1/1/2018 1 1 A 2/1/2018 2 1 A 3/1/2018 2   A 4/1/2018   2 A 5/1/2018 3 1   I tried the following: PRoc sql; SELECT a.* FROM dataset_1 a LEFT JOIN dataset_2 b ON a.group = b.group where a.screen_date = b.rand_date quit;   this gives me matched data: so 3 records match but not 2.    Thankss!! ... View more

Hi I would like to create a boxplot for multiple variables but not just 1 variable   ID time_hour_1 time_hour_2 time_hour_3 time_hour_4 1 40 122 21 12 2 20 112 12 66 3 30 143 14 43 4 35 145 17 43 5 22 124 10 12   I tried Proc Boxplot data = a.test; hbar time_hour_1 time_hour_2; RUN;   Not working. thanks! ... View more

Hi I have this certain code   proc sgplot data=a.data_out; hbar trt_group / response=Percent group=scales groupdisplay=stack ; run;   I would like to use RGB color format for 'scales' variables. I used pattern but it won't work Scales variables has 7 ordinal scales: 0, 1, 2, 3, 4, 5, 6   Any help would be great! THanks Radhika ... View more

Hello,   I need help with creating 1) horizontal stacked bar chart and then 2) giving certain RGB color to a scale:   here is the dataset I have: treatment_group scale percent drug 0 . drug 1 2.5 drug 2 2.5 drug 3 12.5 drug 4 24.2 drug 5 23.3 drug 6 9.2 drug 7 25.8 control 0 . control 1 0.4 control 2 6.0 control 3 12.0 control 4 25.7 control 5 24.1 control 6 12.4 control 7 19.3   I would like to create a stacked bar graph HORIZONTAL. Right now, I have it vertical.   proc sgplot data=a.FreqOut;   vbar treatment_group/ response=Percent group=scale groupdisplay=stack; xaxis discreteorder=data; yaxis grid values=(0 to 100 by 10) label="Percentage of Total"; run;   Also for Each scale, I would like to give a RGB color For examples - Scale 7 should have certain color:cx9999ff - Scale 6 should have certain color=cx993366 - Scale 5 should have certain color=cxffffcc   I tried but no luck! pattern1 v=solid color=cx9999ff;  pattern2 v=solid color=cx993366;  pattern3 v=solid color=cxffffcc;    Any help would be appreciated!! ... View more

Hi. I am trying to replace missing date values to expected date values if it falls before the max dates for EACH subject ID.   Here is the dataset subject_id visit_day expected_visit_date actual_visit_date 1 1 1/1/2017 1/1/2017 1 2 1/2/2017 1/2/2017 1 3 1/3/2017   1 4 1/4/2017 1/4/2017 2 1 2/1/2017 2/1/2017 2 2 2/2/2017   2 3 2/3/2017   2 4 2/4/2017 2/4/2017 2 5 2/5/2017   2 6 2/6/2017 2/6/2017 3 1 3/1/2017 3/1/2017 3 2 3/2/2017 3/2/2017 3 3 3/3/2017 3/3/2017 3 4 3/4/2017 3/4/2017 3 5 3/5/2017 3/5/2017 3 6 3/6/2017     Here is the dataset that I would like:   subject_id visit_day expected_visit_date actual_visit_date visit_date_new 1 1 1/1/2017 1/1/2017 1/1/2017 1 2 1/2/2017 1/2/2017 1/2/2017 1 3 1/3/2017   1/3/2017 1 4 1/4/2017 1/4/2017 1/4/2017 2 1 2/1/2017 2/1/2017 2/1/2017 2 2 2/2/2017   2/2/2017 2 3 2/3/2017   2/3/2017 2 4 2/4/2017 2/4/2017 2/4/2017 2 5 2/5/2017   2/5/2017 2 6 2/6/2017 2/6/2017 2/6/2017 3 1 3/1/2017 3/1/2017 3/1/2017 3 2 3/2/2017 3/2/2017 3/2/2017 3 3 3/3/2017 3/3/2017 3/3/2017 3 4 3/4/2017 3/4/2017 3/4/2017 3 5 3/5/2017 3/5/2017 3/5/2017 3 6 3/6/2017       If the Subject ID 3 does not have any max date value so it is left black since the VISIT was not completed.   I have tried the following code proc sql;  select coalesce(actual_visit_date,expected_visit_date) as new_visit_date   from have; quit;   Thanks! Radhika ... View more

Hi   I am trying to create a time series plot by EACH subject so the output will show graphs for each individual for 3 variables of interest with multiple dates. Each dates have several indexes that I would like to show that too.   Here is the sample dataset:   subjectID aa formGroup i visit_date bb cc 1 16 Day 1 1 1/19/2015 84 68 1 10 Day 1 2 1/19/2015 92 82 1 10 Day 1 3 1/19/2015 100 90 1 8 Day 1 4 1/19/2015 104 96 1 10 Day 2 1 1/20/2015 100 90 1 7 Day 2 2 1/20/2015 100 93 2 10 Day 1 2 4/12/2016 88 78 2 17 Day 1 3 4/12/2016 81 64 2 15 Day 1 4 4/12/2016 84 69 2 17 Day 2 1 4/13/2016 93 76 2 14 Day 2 2 4/13/2016 86 72 2 16 Day 2 4 4/13/2016 74 58   Here is the code I have so far   PROC SGPLOT data = have; BY subjectID; scatter x = visit_date y = aa; scatter x = visit_date y = bb; scatter x = visit_date y = cc; series x = visit_date y = aa; series x = visit_date y = bb; series x = visit_date y = cc; RUN;   However, In addition to the Visit_date, I would like to include "I" variable so to show how values changed within that same day   Any help would be great!!   Thank you ... View more

Hi   I would like to code the following: If date 1 is not filled in, but the subsequent date is filled in then use EXPECTED date for that date. Same for others (date 4 is always filled in).        subject_id date_1 date_1_expected date_2 date_2_expected date_3 date_3_expected date_4 date_4_expected 1111 1/1/2016 1/2/2016   1/7/2016   1/12/2016 1/17/2016 1/17/2016 2222   1/5/2017 1/9/2018 1/10/2017   1/15/2017 1/20/2017 1/20/2017 3333 1/4/2018 1/4/2018   1/9/2018   1/14/2018  1/18/2018 1/19/2018   Right now, I have the following code:  proc sql;  select coalesce(date_1,date_1_expected) as date_1_new   from dataset; quit;   but I would like to add in the constraint that next date is filled    ... View more

Hello. I would like to use PROC SQL command to collapse by group.   For example here is the dataset: subjectid pmh_1 pmh_2 pmh_3 pmh_4 1 1 0 0 0 1 0 1 0 0 1 0 0 0 1 1 0 0 1 0 2 0 0 0 1 2 0 0 1 0 2 1 0 0 0   I want this output (one subject Id per row but summed )   subjectid pmh_1 pmh_2 pmh_3 pmh_4 1 1 1 1 1 2 1 0 1 1 I tried having and group by clause but it wont do much   Thanks so much for your help! ... View more