topic Re: Proc Means help in SAS Programming

Proc Means help

Kalai2008 — Tue, 25 Jul 2017 17:10:07 GMT

I calculated the sum of all the variables using proc means and not sure how to combine them with the main dataset.

Given dataset T

ID var1 var2 var3
1 20 30 52
2 80 20 65
3 42 95 25

Want dataset:

ID var1 var2 var3
1 20 30 52
2 80 20 65
3 42 95 25
Tot 142 145 142

OUTPUT FROM PROC MEANS

Obs _TYPE_ _FR VAR1 VAR2 VAR3

142

145

142

I want to join the sum from proc means to the main dataset T.

Re: Proc Means help

Reeza — Tue, 25 Jul 2017 17:11:50 GMT

That's not really a good idea. If you want totals, you should use a reporting procedure such as PROC PRINT or PROC REPORT or TABULATE. It's too easy to mix up the totals with the data later on.

Anyways, just append the data in, if you used the same variable names. If not, you need to rename them to match and append it.

data want;

set have totals;

run;

Re: Proc Means help

Kalai2008 — Tue, 25 Jul 2017 17:41:08 GMT

Thank you!