Date:         Sun, 18 Oct 1998 01:00:53 GMT
Reply-To:     tedalper@MY-DEJANEWS.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         tedalper@MY-DEJANEWS.COM
Organization: Deja News - The Leader in Internet Discussion
Subject:      PROC REPORT: CHARACTER data under ACROSS columns??

Ok, this should be easy, but at the moment it's driving me up the wall!
 
I have a dataset with three variables, X, Y, and Z.
I want to create a PROC REPORT with X as a GROUP variable (categories
down the left margin), Y as an ACROSS variable (categories across the
top) and Z, which is a CHARACTER variable, as the value in the cell.
 
I know that each combination of X,Y occurs exactly once in my dataset,
so there should be no ambiguity about the value of Z to go in the cell
corresponding to row X, column Y.
If I try to specify Z as an analysis variable, I get empty cells, probably
because Z is CHARACTER, not NUMERIC.
 
E.g., for the dataset
DATA FOO;
INPUT X Y Z $;
CARDS;
1 5 fred
2 5 barney
1 6 wilma
2 6 betty
;
 
I want output like:
       5             6
1     fred        wilma
2     barney      betty
 
 
[I know I could use DATA _null_ for this simple case, but my real application
is much more elaborate.  The simple example stated above is just an idealized
distillation of the problem I can't get past.]
 
If the answer is that proc report can't do it, any clever workarounds would
really be appreciated!
 
Thanks!
Bradley Dalper
 
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own