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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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