LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2003, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 29 Apr 2003 14:12:10 -0700
Reply-To:   Corey872 <imapeppertoo@EXCITE.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Corey872 <imapeppertoo@EXCITE.COM>
Organization:   http://groups.google.com/
Subject:   Re: Generating SAS table?
Content-Type:   text/plain; charset=ISO-8859-1

Hi, all,

Still not quite getting what I would like from my table. I will try to go into a little more detail. For simplicity...I have two class variables...call them MAKE and COLOR. MAKE can be either Ford, Chevy, or Dodge, but only one. COLOR can be red, green, or blue, *or* any combination of these colors.

If using the PROC FREQ command and I simply say TABLE MAKE*COLOR; I get a table with Chevy, Dodge, Ford on the top. But down the side I get red, green, blue, red/blue, red/green, ...etc.

Ideally, I would like to have a simple table with "Chevy, Dodge, Ford" across the top and "Blue, Green, Red" down the side. The cells (for example Chevy x Blue) would show how many cars had ANY blue on them at all.

Basically, the TABLE (A B C D)*E (which in the above instance would be equivalent to TABLE (RED BLUE GREEN)*MAKE command) is getting me about 98% what I want. It is just putting each single color on a separate line with it's own header. I would just like to have all these separate lines in a single table.

Thanks for any assistance.

Corey

rabelson@KAI-RESEARCH.COM (Robert Abelson) wrote in message news:<CF2133F44152D711AE7800065BF699A90CBE60@KAI_EMAIL01>... > Corey, > > Try adding the MISSING option to the TABLE statement, i.e. > > Table A*B*C*D*E / list missing; > > HTH. > > Bob Abelson > KAI > 6001 Montrose Rd. > Suite 920 > Rockville, MD 20852 > T: 301-770-2730 > F: 301-770-4183 > rabelson@kai-research.com > > "Everyone has a photographic memory. Some don't have film." > -Jack Handey > > > > > -----Original Message----- > > From: Corey872 [SMTP:imapeppertoo@EXCITE.COM] > > Sent: Friday, April 25, 2003 12:29 PM > > To: SAS-L@LISTSERV.UGA.EDU > > Subject: Re: Generating SAS table? > > > > Dennis, > > > > Yes I am using PROC FREQ. I tried the line you suggested below and > > for some reason the table does not show up at all. I should also > > mention that I am using SAS 8.2. Also, I believe my variable "A" is > > termed a "class" variable. It has several possible names that it can > > be. The B,C,D...variables are analysis variables. I just want to see > > the frequency with which B,C,D occur for each possibility of "A". > > > > I have a feeling there is something blatantly simple that I am > > overlooking? > > > > Any suggestions greatly appreciated. > > > > A (very) novice SAS user, > > > > Corey > > > > diskin.dennis@KENDLE.COM wrote in message > > news:<OF670E563A.3A93EA5C-ON85256D12.006A6141@kendle.com>... > > > Corey, > > > > > > I assume you are using PROC FREQ: Then do : > > > Table A*B*C*D*E / list; > > > > > > HTH, > > > Dennis Diskin > > > > > > > > > > > > > > > From: Corey872 <imapeppertoo@EXCITE.COM>@LISTSERV.UGA.EDU> on > 04/24/2003 > > > 03:08 PM > > > > > > Please respond to Corey872 <imapeppertoo@EXCITE.COM> > > > > > > Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> > > > > > > > > > To: SAS-L@LISTSERV.UGA.EDU > > > cc: > > > > > > Subject: Generating SAS table? > > > > > > > > > I am using a program statment equivalent to: > > > > > > TABLE A*(B C D E); > > > > > > Which is generating a separate table for A*B, A*C, A*D, etc... > > > > > > I would like to have one table with B,C,D, and E displayed in separate > > > columns for each variable. I have tried to concatenate B,C,D and E = > > > F then simply say TABLE A*F, but that gives every possible combo of > > > B,C,D, and E in the colums also. Is there a simple way to get the > > > table with each variable in a separate column? > > > > > > Thanks, > > > > > > Corey


Back to: Top of message | Previous page | Main SAS-L page