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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1591 views
  • 0 likes
  • 2 in conversation