BookmarkSubscribeRSS Feed
mhtoto
Fluorite | Level 6
I would like the following data output (outcomes over time summed for each patient):
 
patient Out1 Out2 Out3...more output variables...
1          2        1        2
2          1        0        1
3          0        0        6
 
from the following data:
 
patient Out1 Out2 Out3...more output variables...
1          0        0        1
1          1        0        1
1          0        1        0
1          0        0        0
1          1        0        0
2          0        0        0
2          1        0        0
2          0        0        0
2          0        0        1
2          0        0        0
2          .         0        0
2          0        0        0
2          0        .         0
3          0        0        1
3          0        0        1
3          .         0        1
3          .         0        1
3          .         0        1
3          .         0        1
 
Thank you in advance for any help.
2 REPLIES 2
ballardw
Super User

If you need a dataset:

 

Proc summary data=have nway;

   class patient;

   var out:  ; /* any list of variables you want to sum*/

   output out=want sum=; /* the option sum= this way means that the result data set will have the same names, use /autoname to have them named Out1_sum Out2_sum etc. */

run;

 

If a report something like this:

Proc tabulate data=have;

   class patient;

   var out: ; /* again list of variables*/

   table patient,

            (out:  )*sum=;

run;

Repeat the variables from the VAR statement to inside the ()

mhtoto
Fluorite | Level 6

Thank you ballardw for your help, much appreciated.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1516 views
  • 0 likes
  • 2 in conversation