Date: Sun, 18 Oct 1998 01:00:53 GMT
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
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
INPUT X Y Z $;
1 5 fred
2 5 barney
1 6 wilma
2 6 betty
I want output like:
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!
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own