Hi,   I have two datasets with patid and numerous other variables. I want to combine both datasets vertically, but with no repeat patid. For example:   data dataset1;                         input patID year x y $ ;          datalines;         1 2011 34 Yes 2 2012 32 Yes 3 2015 56 No 4 2018 57 No 5 2019 78 Yes 6 2020 66 No ;               run;   data dataset2;                         input patID year x y $ ;          datalines;         1 2011 43 Yes 2 2014 32 No 3 2015 56 No 4 2018 56 Yes 5 2021 90 Yes 6 2020 66 No ;               run;   Dataset 1: patid Year X Z 1 2011 34 Yes 2 2012 32 Yes 3 2015 56 No 4 2018 57 No 5 2019 78 Yes 6 2020 66 No   Dataset 2: patid Year X Y 1 2011 43 Yes 2 2014 32 No 3 2015 56 No 4 2018 56 Yes 5 2021 90 Yes 6 2020 66 No   Want: patid Year X Y 1 2011 34 Yes 2 2012 32 Yes 2 2014 32 No 3 2015 56 No 4 2018 57 No 5 2019 78 Yes 5 2021 90 Yes 6 2020 66     Here, I combine dataset 1 and dataset 2 by Id and Year: - if all variables match then output. - If all variables didn't match (except Id and Year) then keep dataset 1 observations. - if Id or Year don't match then create a new row in the new dataset.   Thanks, sandyzman1   ... View more

Hi, I am trying to create a line graph using Proc SGPLOT with both overall p-value and pair-wise p-values. I was able to add the overall p-value using the INSET statement.   However, I also want to add the pair-wise p-values for 3 different age groups (above graph) similar to the plot below:   Is there any way to add the pair-wise p-values to the plot in SAS? Thanks.   -Sandyzman1 ... View more

Hi All,   I have  the following dataset:    patid y wt bmi 1 -4 130 26 1 -2 120 25 1 0 100 24 1 1 99 22 2 -1 120 24 2 0 110 23 2 2 98 21 3 -3 155 25 3 0 120 23 4 -8 130 23 4 -7 112 24 5 -9 145 25 5 -4 123 24 5 1 100 23 5 3 85 21 6 -8 130 25 6 1 85 20   I want to extract the post-wt and post-BMI from WT and BMI that is at y = 0 or closest to y toward negative values (first wt/bmi observation before 0), and create the following table:   patid y wt bmi post_wt Post_BMI 1 -4 130 26     1 -2 120 25     1 0 100 24 100 24 1 1 99 22     2 -1 120 24     2 0 110 23 110 23 2 2 98 21     3 -3 155 25     3 0 120 23 120 23 4 -8 130 23     4 -7 112 24 120 23 5 -9 145 25     5 -4 123 24 123 24 5 1 100 23     5 3 85 21     6 -8 130 25 130 25 6 1 85 20       The SAS code for the "have" table:     data have; input patid y wt bmi; datalines; 1 -4 130 26 1 -2 120 25 1 0 100 24 1 1 99 22 2 -1 128 24 2 0 110 23 2 2 98 21 3 -3 155 25 3 0 120 23 4 -8 130 24 4 -7 112 23 5 -9 145 25 5 -4 123 24 5 1 100 23 5 3 85 21 6 0 90 21 6 1 85 20 ; run;     Thanks, Sandyzman1   ... View more

Hi,   I want to add the flag column in the following table:   id Visit Flag 1 1 1 1 2 1 1 5 0 1 4 x 1 3 x 2 1 1 2 2 1 2 3 1 2 5 0 2 4 x 3 1 1 3 5 0 3 2 x 3 3 x 3 4 x   I have the two columns for patient id and the number of clinic visits. The BMI was measured on each visit (1-5), and visit 5 is the final diagnosis of disease was made. There were few visits that were made after the final diagnosis, which is after visit 5. I wanted to flag 1 for prior diagnosis visit, flag 0 for diagnosis visit (5), and X for those visits after diagnosis (5). Would any please help me add a flag column to the above table? Thanks. ... View more

Hi All,   I am trying to extract the BMI value before and after the surgery for following dataset:   data diff_date; input Date_Visit $ ID $ surgery $ BMI ; cards; 07022002 1 0 40 11142002 1 0 35 05152003 1 1 35 11042003 1 0 25 05042004 2 0 50 11102004 2 0 53 05032005 2 1 45 05032006 2 0 32 05032007 2 0 25 11012005 3 0 30 06062006 3 1 25 07032006 3 0 18 ; run;   I wanted to extract the BMI value 6 months before the surgery, on the day of surgery, and 6 months after the surgery. I would really appreciate any thought. Thanks.   Best, Sandyzman1 ... View more

Hi All, I want to copy the variable name from the last group to all the other observations in the same group. For example, copying the last variable name (Country) in Category to all the blank space in the category.   I have a dataset: Category Country Group    US 1   Israel 1   Canada 1 Country Australia 1   US 2   Israel 2   Canada 2 Country Australia 2   I want:  Category Country Group  Country US 1 Country Israel 1 Country Canada 1 Country Australia 1 Country US 2 Country Israel 2 Country Canada 2 Country Australia 2   The code for the dataset I have:  data have; infile datalines delimiter=','; input Category $ Country $ group$; datalines;   ,USA , 1 ,ISRAEL ,1 ,CANADA, 1 Country, AUSTRALIA ,1  ,USA, 2 ,ISRAEL ,2 ,CANADA, 2 Country, AUSTRALIA ,2 ; run;   Thanks.  Best, Sandyzman1 ... View more