Date:         Mon, 3 Oct 2005 13:06:46 -0700
Reply-To:     toby989@HOTPOP.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby989@HOTPOP.COM
Subject:      Outputting Ns of cells into different Vars TAB FREQ MEANS
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi All

I want to create a summary of two variables, one with 100 levels, the
other one with 3 levels, into a table that shows the Ns by cell. FREQ,
TABULATE or MEANS procedure create one row for each level combination
(100x3=300rows) and put the numbers into one variable, but for further
processing, i need a dataset with 100 rows and 3 variables.

I would be so grateful for your help on this.

Thanks Toby


1 1
1 1
1 2
1 2
1 3
1 3
1 3
2 1
2 2
2 2
2 3
3 1
3 1
.
.
.
99

into

1 2 2 3
2 1 2 1
3 2 ...
.
.
99