topic Re: PROC MEANS multiple variables in SAS Programming

PROC MEANS multiple variables

pacman94 — Tue, 08 Jun 2021 14:15:59 GMT

I would like to take MEAN and Standard Deviation by Arms for Var1 through Var6

Here is the dataset

ID	Var1	Var2	Var3	Var4	Var5	Var6	Arm
1	5	6	1	9		9	A
2	6	1		11	56	12	B
3	9		12	22			A
4		3	6	6	10		A
5	6	6	3			5	A
6	15	4		7	6	9	A
7		1	4				B

PROC MEANS DATA = test NOPRINT COMPLETETYPES;
FORMAT Arm Arm.;
CLASS Arm/PRELOADFMT;
VAR Var1 Var2 Var3 Var4 Var5 Var6;
OUTPUT OUT = test2(keep = Arm N MEAN STD)
N = N MEAN = MEAN STD = STD;
RUN;

It doesn't pick up all Vars. Just the first one

Re: PROC MEANS multiple variables

PaigeMiller — Tue, 08 Jun 2021 14:31:24 GMT

perhaps this fixes it ... if not, explain further

PROC MEANS DATA = test NOPRINT COMPLETETYPES;
FORMAT Arm Arm.;
CLASS Arm/PRELOADFMT;
VAR Var1 Var2 Var3 Var4 Var5 Var6;
OUTPUT OUT = test2 N= MEAN= STD= /autoname;
RUN;

Re: PROC MEANS multiple variables

Reeza — Tue, 08 Jun 2021 14:26:54 GMT

You only listed one name after the variables you specified, Ie N = N. You need to provide a variable name for each value, N = N1-N6 instead.
Or don't specify anything and let SAS name it using the autoname option as illustrated by PaigeMiller.