topic Re: Proc sql average vs proc means; in SAS Procedures

Proc sql average vs proc means;

Alass006 — Mon, 28 May 2018 16:34:27 GMT

Hello there,

There is a statement in stat proc means that I am trying to find the equivalence in proc sql average.

If I want to compute the means and including missing values

proc means= data mean missing;

var y;

output out=yout mean= Avg std=SD;

run;

proc sql;

select *, avg(y)

from data;

quit.

Is there any way to include a missing statement in proc sql ?

Thanks in advance

Re: Proc sql average vs proc means;

art297 — Mon, 16 Jun 2025 12:24:33 GMT

Since proc mean's missing option only concerns missing class variables, there would be no difference in using SQL's avg or proc means.

Art, CEO, AnalystFinder.com

From @Reeza :

It's not clear how you want to include missing. If you essentially want them treated as 0, it's easiest to recode them and summarize on that, or you can use the sum() / COUNT() of the total number of rows, which would include the missing in the denominator.

@Alass006 wrote:
Hello there,

There is a statement in stat proc means that I am trying to find the equivalence in proc sql average.

If I want to compute the means and including missing values

proc means= data mean missing;

var y;

output out=yout mean= Avg std=SD;

run;

proc sql;

select *, avg(y)

from data;

quit.

Is there any way to include a missing statement in proc sql ?

Thanks in advance

Re: Proc sql average vs proc means;

Astounding — Mon, 28 May 2018 16:51:20 GMT

And on a related note, the sample PROC MEANS that you posted would produce the same results, whether or not the MISSING option is present. You might need to see a few examples of how MISSING affects the results ... as @art297 mentioned, those examples will include a CLASS statement,.

Just curious, how are you picturing that the results would change if missing values are included vs. excluded?

Re: Proc sql average vs proc means;

Reeza — Mon, 28 May 2018 17:16:50 GMT

It's not clear how you want to include missing. If you essentially want them treated as 0, it's easiest to recode them and summarize on that, or you can use the sum() / COUNT() of the total number of rows, which would include the missing in the denominator.

@Alass006 wrote:

Hello there,

There is a statement in stat proc means that I am trying to find the equivalence in proc sql average.

If I want to compute the means and including missing values

proc means= data mean missing;

var y;

output out=yout mean= Avg std=SD;

run;

proc sql;

select *, avg(y)

from data;

quit.

Is there any way to include a missing statement in proc sql ?

Thanks in advance