topic Re: Proc Summary ( mean and Sum) in Statistical Procedures

Proc Summary ( mean and Sum)

amager — Thu, 17 Aug 2017 09:30:37 GMT

Hi everyone,

I want to summarize all variables and to calulate mean juste for one variable x. my proc summary is it correct ?

proc summary data=table_tosum ; 
	var &variables_to_sum.; 
	by DD DF;
	id  a b c d &other_variables. ;
	output out=table (drop= _TYPE_ _FREQ_ _ORGA ) sum()= mean(x)=;
run;

thanks.

Re: Proc Summary ( mean and Sum)

amager — Thu, 17 Aug 2017 13:06:49 GMT

any suggestion

Re: Proc Summary ( mean and Sum)

Astounding — Thu, 17 Aug 2017 13:25:36 GMT

What is _ORGA?

If you want the sum of all variables, as part of the OUTPUT statement remove the parentheses and use:

sum=

Re: Proc Summary ( mean and Sum)

Reeza — Thu, 17 Aug 2017 15:03:49 GMT

Run it and checking is faster than waiting for a response.

Re: Proc Summary ( mean and Sum)

ballardw — Thu, 17 Aug 2017 15:39:53 GMT

@amager wrote:

Hi everyone,

I want to summarize all variables and to calulate mean juste for one variable x. my proc summary is it correct ?
proc summary data=table_tosum ; 
	var &variables_to_sum.; 
	by DD DF;
	id  a b c d &other_variables. ;
	output out=table (drop= _TYPE_ _FREQ_ _ORGA ) sum()= mean(x)=;
run;
thanks.

Placing the fixed name of a variable into one position of code such as mean(x) when that variable is not explicitly listed on the var statement is a likely point of code failure in the future when the macro variable &variables_to_sum does not contain x.