Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Using a CLASS statement in PROC SUMMARY does not require the data set to be sorted in advance. The CLASS statement will collapse observations with the same variable values. The _FREQ_ variable in the output data set shows the frequency count of observations with that combination of CLASS variable values. Click on the Results tab to see the resulting data set.

    /* Example */

    /* Create a data set with duplicate observations */
    data test;
    input x y z;
    cards;
    1 1 1
    1 1 1
    1 2 1
    1 2 2
    2 2 2
    2 2 2
    2 2 2
    2 2 1
    ;
    run;
    
    proc summary data=test nway;
    class x y z;
    output out=test1(drop=_type_);
    run;

    proc print data=test1;
    run;

Operating System and Release Information

Obs    x    y    z    _FREQ_

 1     1    1    1       2
 2     1    2    1       1
 3     1    2    2       1
 4     2    2    1       1
 5     2    2    2       3