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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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