Date:         Mon, 18 Mar 1996 07:51:56 -0500
Reply-To:     Elizabeth A Franks <franksea@SBAC.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Elizabeth A Franks <franksea@SBAC.EDU>
Subject:      Cum % & freq (from quasi-novice)

I am asked to establish local norms for test data (several subtests,
several grades).  Proc freq would be perfect EXCEPT the output dataset
from proc freq does NOT include cumulative frequency and cumulative
percentage columns.  Some subtests have 24 itmes; others have nearly 100.
 
Is there any PROC that will give me cumulative percentage and cumulative
frequency in an OUTPUT DATASET?  If no PROC will give me the information
I need, then I can take PROC FREQ output (COUNT, PERCENT) and compute the
cums myself.  In that case, what programming statement will produce the
cumulative freqs and percents on an item by item basis (when each item
appears to be a record unto itself)?  The final
product to be used when doing these local norms will be a number of
datasets (one for each subtest, grade, level, etc.) that can be read into
a program to convert each person's subtest score into a local percentile.
 
                    SAS       SAS      I NEED     I NEED
                    SUPLIES  SUPPLIES  in a file  in a file
For example,  ITEM  COUNT    PERCENT   CUM FREQ   CUM PERCENT
 
               1      8        0.5         8       0.5
               2      2        0.1        10       0.5
               3     20        1.0        30       1.5
               .
               .etc
        e.g., 24    500       25.5       1963    100.0
 
Maybe someone has worked with this type of problem before.  Thanks in
advance.  I'll send a summary of answer to the list after I receive and
do.
 
Betty Ann Franks