Date: Wed, 22 Oct 1997 17:15:43 -0500
Reply-To: Steve Des Jardins <s-desj@MAROON.TC.UMN.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Steve Des Jardins <s-desj@MAROON.TC.UMN.EDU>
Content-Type: text/plain; charset="us-ascii"
Proc Report gurus:
I need help. The input data is:
fileno fcmps funit retn year regsta;
(student id, entry campus, entry unit, enrollment status, year,
registration status)
all are numeric variables.
Here's the code:
PROC REPORT HEADSKIP NOWD PSPACE=2 MISSING;
WHERE REGSTA=1;
COLUMN FCMPS FUNIT RETN YEAR;
DEFINE FCMPS/GROUP WIDTH=11 ORDER=INTERNAL;
DEFINE FUNIT/GROUP WIDTH=15 ORDER=INTERNAL;
DEFINE RETN/GROUP WIDTH=12 ORDER=INTERNAL;
DEFINE YEAR/ACROSS WIDTH=6;
BREAK AFTER FUNIT/SKIP SUMMARIZE;
Here's the output:
ENTRY FALL
CAMPUS: ENTRY UNIT: ENROLLMENT: 1988 1989 1990
1991
TWIN CITIES DENTAL HYGIENE ENROLLED 0 0 0 0
TWIN CITIES DENTAL HYGIENE 0 0 0 0
INSTITUTE TECHN ENROLLED 605 598 567 4
NOT ENROLLED 85 62 57
TWIN CITIES INSTITUTE TECHN 690 660 624 5
LIBERAL ARTS ENROLLED 1874 1694 1516 13
NOT ENROLLED 451 369 397 2
TWIN CITIES LIBERAL ARTS 2325 2063 1913 16
GENERAL COLLEGE ENROLLED 595 549 514 5
NOT ENROLLED 278 260 253 2
TWIN CITIES GENERAL COLLEGE 873 809 767 7
ETC.........
How can I calculate percentages by FUNIT? For example, Liberal Arts
Enrolled=1874, total Liberal Arts=2325, how to calculate percent ENROLLED
(1874/2325 or 80.6%)? Same for the NOT ENROLLED folks (451/2325=19.4%)?
Also, is there a way to make NOT ENROLLED for Dental Hygiene display even
though there is noone in that category (so that all entry units have two
FALL ENROLLMENT rows plus a summary row)?
I hope I've provided enough information. If not, let me know and thank you
all.
Steve
Stephen L. DesJardins Phone:(612) 625-2579
Senior Analyst Fax: (612)624-6057
Office of Planning and Analysis E-mail: s-desj@tc.umn.edu
University of Minnesota
160 Morrill Hall
100 Church St. SE
Minneapolis, MN 55455
Web Page: http://www.opa.pres.umn.edu/personal/sdesj/sdesj.htm
