Date: Tue, 1 Oct 1996 09:43:01 -0400
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: How to avoid x-freqs/summaries?
I am working with student files containing a number of variables.
Twenty-six variables pertain to participation in a special education
program. A student can be in no programs, or in a number of programs
ranging from 1 program to several of the 26 programs.
My program will merge this file (with one record per student) to an
academic history file for which there could be multiple records per
student. In this academic file, I have defined seven areas of
vocational education. Each area is defined by combinations of courses.
For example the agriculture area has 10 courses within that area.
The voc ed person wants duplicated and non-duplicated numbers of persons
and that is no problem for me to get. However, she also wants a
DUPLICATED number of "participaTIONS (not particiPANTS) in special
education programs" for each area of vocational education. As you can
see, this is different than "duplicated and nonduplicated number of
vocational STUDENTS in ese programs".
I can do this by proc freqs, with every one of the 26 special education
variables, but it produces many pages of output for her to go through. Is
there a way to sum, for each person, the number of special education
programs in which he/she is served (when if served in a program = 'Y' else
the field is blank -- over 26 variables ) ? Then maybe I can simply do
proc summaries or freqs-- but just one?
Your suggestions will be appreciated!
Betty Ann Franks
Alachua County School District