Date: Wed, 17 Nov 1999 15:37:37 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: 2-way Frequecy table output
I'm wondering if there's a way to export a 2-way frenquency table output
easily into Excel. In another word, what's the best way to take the
output in the cross-tab format into Excel.
For example, if I have the following:
TABLE OF X BY Y
Frequencyfemale male Total
a 1 2 3
b 2 1 3
c 2 1 3
Total 5 4 9
If I save the original output into a txt file and then import it into
Excel, I need to clean up the format quite a bit. If I add the out=
option, the output data set turns into a different format:
1 a female 1 11.1111
2 a male 2 22.2222
3 b female 2 22.2222
4 b male 1 11.1111
5 c female 2 22.2222
6 c male 1 11.1111
Bottomline is that I need to present the results in a cross-tab format
in Excel. When the distinct values for x and y are not too many, it's
managable though time-consuming, but when there're tons of values for
both variables, I don't know what to do then..
Sent via Deja.com http://www.deja.com/
Before you buy.