Date:         Wed, 22 Dec 2004 12:31:29 -0800
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: Proc Freq
Comments: To: "mchandle@UWINDSOR.CA" <mchandle@UWINDSOR.CA>

Mathew -

I would think a simple proc summary would give you the counts you are after:

Proc summary data=SETeval noprint;
     by ID Prof Rubric Enroll;
     class Rubric;
     types Rubric;
     output  out=data1;

Proc summary data=SETeval noprint;
     by ID Prof Faculty Rubric Enroll;
     class A1-A9 An10-An12 B1-B9 Bn10-Bn15 D1-D9 Dn10-Dn12;
     types A1-A9 An10-An12 B1-B9 Bn10-Bn15 D1-D9 Dn10-Dn12;
     output  out=data2;

data data3;
     set data1 data2;

PROC EXPORT DATA= data3
     OUTFILE= "exported_counts.csv"
     DBMS=CSV REPLACE;
RUN;

Hth

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mathew
Chandler
Sent: Tuesday, December 21, 2004 1:27 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Freq

Proc Freq data=SETeval noprint;
  by ID Prof Rubric Enroll;
  Tables Rubric / nocum nopercent out=data1;

Proc Freq data=SETeval noprint;
  by ID Prof Faculty Rubric Enroll;
  tables A1-A9 An10-An12 B1-B9 Bn10-Bn15 D1-D9 Dn10-Dn12 / Out=data2 nocum
nopercent;

A number of questions:
1.  Can seem to supress the percentages.  I thought that nopercent was
supposed to do this, but it is not.
2.  How do I get the second PRoc Freq to output all of the frequencies to
the table and not just the last (Dn12)?  Or do I have to do each frequency
with a separate proc and then merge them?
3.  The ultimate objective is to produce a data file that is comma
delimited or delimited with another character between fields.  Can SAS do
this, once the dataset is created?

Mathew Chandler
Associate Computing Consultant-Client Support & Services
I.T. Services
University of Windsor
Windsor, Ontario, Canada
N9B 3P4
(519) 253-3000 ext. 2768
mchandle@uwindsor.ca