Date:         Wed, 21 May 1997 17:30:15 +0200
Reply-To:     163871yc@student.eur.nl
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Chen, Y." <163871yc@STUDENT.EUR.NL>
Organization: Erasmus University Rotterdam
Subject:      How do I define the cell in percentage of one category of a
              variable in proc tabulate?
Content-Type: text/plain; charset=us-ascii

Dear SAS users,
 
First Question: I have a data set like this:
 
age         gender   change
 
65-          male     yes
65-          male     no
65-          female   yes
70-          female   yes
70-          female   no
70-          male     yes
70-          male     yes
70-          male     no
 
I want to make a cross tabulation with the three variables like this:
------------------------------------
             Percent of Change
AGE   ------------------------------
           Male        Female
 
60-         50.0        100.0
70-         66.7         50.0
------------------------------------
 
Can I do this with Proc tabulate in one step without producing
percentage for each category (yes/no) of variable 'change'?
 
Second question: I may create much bigger table with Proc tabulate and
export it into Word. I understand that if I use TAB as separator then I
may paste the result into Word more elegantly (use Paste Special in
WORD). But how do I define TAB as separator in Proc tabulate?  I am
using SAS 6.10 for windows.
 
Thank you very much.
 
Ying Chen, Dsc candidate
NIHES, Erasmus University Rotterdam
Email: 163871yc@student.eur.nl
http://www.geocities.com/Tokyo/5246