This is my first time creating graphs in SAS and need some direction. How can I create a line graph for each patient below for score1? I want visits on the x-axis and score on the y-axis. There should be 3 lines representing each of the 3 patients on one graph.    Visit Patient score1 Week1 1 0 Week2 1 0.8 Week3 1 1.1 Week4 1 2 Week1 2 1 Week2 2 1 Week3 2 1.5 Week4 2 1.6 Week1 3 0.8 Week2 3 0.9 Week3 3 1.2 Week4 3 1.4 ... View more

Hi all,   I'm hoping to get descriptive statistics (n mean stddev min max median 95% CLM) on the sample data below. So, VISIT on the vertical pane going down and TIB_GROUP across on the top.   Visit Patient TIB_GROUP SCORE 1 1 1 85.29 2 1 1 61.76 3 4 1 59.35 1 2 0 44.12 2 2 0 58.82 1 3 2 80.88 2 3 2 86.76 1 4 1 42.89 2 4 1 23.53 3 4 1 69.12 1 5 0 79.41 2 5 0 66.18 3 5 0 92.65 1 6 0 69.12 2 6 0 76.47 1 7 2 97.06 2 7 2 97.06 1 8 1 72.06 2 8 1 73.53 How can I use proc means or proc tabulate for this? I'm having trouble getting all the descriptive stats I need ... View more

  Hi all, I'm looking to create some summary statistic as seen below   Is it possible to combine the results of 2 proc means? Using the data below, I want to calculate proc means with 2 different classes. Like so: proc means data= have n min max median mean stddev maxdec=1 ; class con parameter_n parameter ; var score; output out=overall; run;   proc means data= have n min max median mean stddev maxdec=1 ; class con parameter_n parameter site ; var score; output out=bysite; run;   MEMBER SITE PARAMETER PARAMETER_N SCORE CON 1 A OSUT 1 12 ARI 1 A OCDT 2 12 ARI 2 A OSUT 1 32 ARI 2 A OCDT 2 37 ARI 3 A OSUT 1 31 ARI 3 A OCDT 2 24 ARI 4 A OSUT 1 34 ARI 4 A OCDT 2 24 ARI 5 A OSUT 1 37 ARI 5 A OCDT 2 20 ARI 22 A OSUT 1 21 ASI 22 A OCDT 2 48 ASI 25 A OSUT 1 21 ASI 25 A OCDT 2 41 ASI 26 A OSUT 1 23 ASI 26 A OCDT 2 42 ASI 27 A OSUT 1 32 ASI 27 A OCDT 2 52 ASI 28 A OSUT 1 30 ASI 28 A OCDT 2 44 ASI 9 B OSUT 1 39 ARI 9 B OCDT 2 25 ARI 10 B OSUT 1 29 ARI 10 B OCDT 2 27 ARI 11 B OSUT 1 29 ARI 11 B OCDT 2 23 ARI 15 B OSUT 1 33 ARI 15 B OCDT 2 29 ARI 16 B OSUT 1 27 ARI 16 B OCDT 2 36 ARI 17 B OSUT 1 29 ASI 17 B OCDT 2 32 ASI 20 B OSUT 1 13 ASI 20 B OCDT 2 36 ASI 21 B OSUT 1 39 ASI 21 B OCDT 2 34 ASI 22 B OSUT 1 6 ASI 22 B OCDT 2 32 ASI 23 B OSUT 1 18 ASI 23 B OCDT 2 33 ASI   My results should like like this:   Parameter     Site         Statistics         ARI                ASI           Diff ASI - ARI OSUT         Overall            n                  xx                  xx                 -xx                                     mean (SD)      xx.x(x.x)       xx.x(x.x)                                           median               xx.x             xx.x                                     Min, Max          xx,  xx          xx, xx                                      95% CI          xx.x, xx.x     xx.x, xx.x       -xx.x, -x.x                                      P-value                                                   <0.0001                         A                 n                  xx                  xx                 -xx                                     mean (SD)      xx.x(x.x)       xx.x(x.x)                                           median               xx.x             xx.x                                     Min, Max          xx,  xx          xx, xx                                      95% CI          xx.x, xx.x     xx.x, xx.x       -xx.x, -x.x                                      P-value                                                   <0.0001                           B                 n                  xx                  xx                 -xx                                     mean (SD)      xx.x(x.x)       xx.x(x.x)                                           median               xx.x             xx.x                                     Min, Max          xx,  xx          xx, xx                                      95% CI          xx.x, xx.x     xx.x, xx.x       -xx.x, -x.x                                      P-value                                                   <0.0001   Repeat for parameter OCDT   Not sure if this is possible.  I get close to what I want using proc univariate but the output just looks like raw data. I prefer the cleaner look in proc means. ... View more

Hi all,   I have the below dataset and trying to create a new variable  (Location2).   looking at every row for each person, if there is only one row of data per person, then location2 = location if there are multiple rows of data per person and location is consistent for each person, then location2 = location if there are multiple rows of data per person but location is not consistent, then location2 = 'Both'   I've tried using a do-loop but it isn't quite working as I want.   Person date Location Location2 1001 20190629 DC DC 1007 20190124 Maryland Both 1007 20191105 DC Both 2364 20191203 Maryland MD 2364 20190405 Maryland MD 3331 20190101 Maryland MD 6579 20190325 DC DC 6579 20190404 DC DC 6579 20190416 DC DC 6579 20190504 DC DC 6579 20190717 DC DC 6579 20190807 DC DC 6579 20191101 DC DC 1034 20190219 Maryland Both 1034 20191019 DC Both 1035 20190301 Maryland Both 1035 20191201 DC Both ... View more

Hi,   So I have the dataset below and want to create a new variable (Weight_to_use). If year = 2017 then weight_to_use should be populated from Weight_17. If year = 2018, then weight_to_use should be 135 from Weight_18. etc. etc.   I'm not sure how to right this logic. Any ideas?   Year ID Weight_17 Weight_18 Weight_19 Weight_to_use 2017 1234 130 135 132   2018 3344 234 250 244   2019 9999 180 192 167   ... View more