Hello everyone,    I want to change(replace) values in sashelp.class for weight/height/age variables. this is just for understanding the concept. Suppose this our data : Obs Name Sex Age Height Weight 1 Alfred M 14 69.0 112.5 2 Alice F 13 56.5 84.0 3 Barbara F 13 65.3 98.0 4 Carol F 14 62.8 102.5 5 Henry M 14 63.5 102.5 6 James M 12 57.3 83.0 7 Jane F 12 59.8 84.5 8 Janet F 15 62.5 112.5 9 Jeffrey M 13 62.5 84.0 10 John M 12 59.0 99.5 11 Joyce F 11 51.3 50.5 12 Judy F 14 64.3 90.0 13 Louise F 12 56.3 77.0 14 Mary F 15 66.5 112.0 15 Philip M 16 72.0 150.0 16 Robert M 12 64.8 128.0 17 Ronald M 15 67.0 133.0 18 Thomas M 11 57.5 85.0 19 William M 15 66.5 112.0   I am willing to change weight variable values to 9999 if the observation is between 120 - 150. Thanks for the help! ... View more

Hello everyone!   I have one data set with more than 30 variables. I am mentioning her only three of them for reference. I want to group SUBJID, TRT and mean value of VAlL which would be a new variable and have to keep other variables in data-set. i tried Proc sql but getting error while mentioning other variables. Imp point, I have to group SUBJID and TRT.  Please help me out with this issue.    data have; SUBJID        TRT                  val          mean_value 10001        Screening            2.3 10001        Screening            3.6          10001        Week24               2.3 10001         Week24              3.6 10002          Week24              3.6 10002          Screening           3.6 10002          Screening            3.6 10002          Week24              2.3 10003          Screening          2.3 10003          Screening          2.3 10003           Week24            2.3 10003          Week24             3.6         data want;   SUBJID        TRT                           mean_value 10001        Screening                     4.1                   Week24                        4.1         10002          Week24                       4.1                      Screening                   4.1   10003          Screening                     4.1                      Week24                     4.1   ... View more

HI all,   I am trying to get to know the min and max value of date in a variable in data step . I ll share a sample data set and appreciate if some one can help me out.  I have applied min max function but it is giving same value to every observation.  I am wishing to create two new variable with min(startdate) and max(end date) corresponding to their SUBJID . Thanks!   Sample -    SUBJID     Visitdate 101-02       15AUG17 101-02       14AUG18 101-02       24Sep17 101-02        101-04       10JAN18 101-04       14DEC18  101-04       07DEC17 101-04 101-07       13MAR17 101-07       28JUL17 101-07       22APR18 101-07       18JAN19 101-07 ... View more