Several ways:
Use the NWAY option on the PROC MEANS statement so you only have the highest level.
Use the WAYS or TYPES statement to explicitly control the levels
Use a BY statement instead of CLASS
Use a PROC SQL instead if only doing a single statistics it's relatively easy.
@CeliaAlonso wrote:
Good morning,
I have a problem with the PROC MEANS procedure.
The problem is that I have a table with two variables
-cod (is a code, numeric)
-cod2 (is another code, numeric)
What I want to do is to make a PROC MEANS summarizing by cod and cod2. But PROC MEANS procedure gives me the variables _TYPE_ and _FREQ_ summarizing the variable cod and then the variable cod2 instead of doing together.
My code is:
proc means data=data.table1 noprint; class cod cod2; output out=data.table2; run;
... View more