DATA Step, Macro, Functions and more

Proc summary very basic question?

Reply
Frequent Learner
Posts: 1

Proc summary very basic question?

Hi Friend,

 

I am new to SAS and while solving the problem stuck in very basic step. I have three coloumn data is like Grade sub Grade and their average value. I have take average of Grade and Sub-grade. Thank you...

 

Data Example

InputData   Output  
Col 1Col 2Avg  Average of Avg 
AA115  Col 1Col 2Total
AA213  AA115
AA316   A213
AA411   A316
BB112   A411
BB211  A Avg 13.75
BB313  BB112
CC117   B211
CC218   B313
CC313  B Avg 12
CC420  CC117
CC520   C218
      C313
      C420
      C520
     C Avg 17.6
     Grand Total 14.91666667
Super User
Posts: 19,862

Re: Proc summary very basic question?

Posted in reply to Pundalik_Rathod

That's actually better done in either proc report or tabulate. 

Possibly proc PRINT as well.

SAS Super FREQ
Posts: 8,868

Re: Proc summary very basic question?

PROC PRINT will only do the SUM at the subtotal and grand total rows on the report. So, Reeza's first instinct was correct to use either REPORT or TABULATE.

cynthia
Super User
Posts: 11,343

Re: Proc summary very basic question?

Posted in reply to Pundalik_Rathod

One way:

 

data have;
   informat Col1  Col2 $5. Avg best5.;
   input Col1  Col2  Avg ;
   label 
      Col1 = "Col 1"
      Col2 = "Col 2"
   ;
datalines;
A A1 15   
A A2 13  
A A3 16  
A A4 11  
B B1 12  
B B2 11  
B B3 13  
C C1 17  
C C2 18  
C C3 13  
C C4 20  
C C5 20  
run;

proc tabulate data=have;
   class col1 col2;
   var avg;
   table col1*(col2 All='Group Avg') All='Grand Total',
         avg=''*mean='Total'*f=best7.;
run;

Adjust the format for the desired number of decimals.

 

Ask a Question
Discussion stats
  • 3 replies
  • 135 views
  • 0 likes
  • 4 in conversation