Date: Tue, 7 Jul 2009 13:57:39 -0400
Reply-To: "Kirby, Ted" <ted.kirby@LEWIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Kirby, Ted" <ted.kirby@LEWIN.COM>
Subject: Re: Proc Tabulate
In-Reply-To: A<F11A078E5B134649AB7D83141F625B6810470F@chgmail1.diamondconsultants.net>
Content-Type: text/plain; charset="us-ascii"
Try this code. I just ran it on a little dataset and it seemed to
create a table in the format you want.
proc tabulate data=test;
class gender region;
var transactions;
table gender,transactions*(sum=" "*(region all) rowpctsum=" "*(region
all)); run;
----Ted Kirby,
Senior Associate,
The Lewin Group, Inc.
3130 Faivew Park Drive, Suite 800
Falls Church, VA 22042
e-mail: ted.kirby@lewin.com
P: (703)269-5507
F: (703)269-5501
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Mathur, Rajat
Sent: Tuesday, July 07, 2009 11:13 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Tabulate
Hi Ya,
Thanks for your mail.. but I guess in the mail my formatting got screwed
up, I am looking for something like this:
http://www.geocities.com/poppin_mathur/ProcTabulate.xls
Please let me know what is the correct code to use
Regards,
Rajat
-----Original Message-----
From: Ya Huang [mailto:ya.huang@AMYLIN.COM]
Sent: Tuesday, July 07, 2009 8:37 PM
To: SAS-L@LISTSERV.UGA.EDU; Mathur, Rajat
Cc: Ya Huang
Subject: Re: Proc Tabulate
Something like this should work:
proc tabulate data=xx;
class gender region;
var trans;
table (region gender)*sum, trans;
run;
On Tue, 7 Jul 2009 09:41:41 -0500, Mathur, Rajat
<Rajat.Mathur@DIAMONDCONSULTANTS.COM> wrote:
>Hi,
>
>I am having trouble in proc tabulate and request your help in resolving
it. Please allow me to explain the data - I have three variables Gender,
Region and Number_of_Transactions
>
>I wanted my report to be like:
>
>Sum of Number of Transactions
>
>East
>
>North
>
>South
>
>West
>
>Female
>
>
>
>
>
>
>
>
>
>Male
>
>
>
>
>
>
>
>
>
>
>Please suggest me, what is the right code that I should be writing...
>
>Thanks
>Rajat
>
>________________________________
>This transmission may (i) be subject to contractual, statutory or other
obligations of confidentiality; (ii) contain "protected health
information " as defined in HIPAA or "non-public personal information "
as defined under data privacy laws; or (iii) be otherwise strictly
confidential. If you are not the intended recipient of this message, you
may not disclose, print, copy or disseminate this information. If you
have received this in error, please reply to the sender only and delete
the message. Unauthorized interception of this e-mail is a violation of
federal law. Diamond's operating subsidiary in North America is Diamond
Management & Technology Consultants NA, Inc.; in the U.K. and Europe,
Diamond Management & Technology Consultants Limited; and in Asia,
Diamond Management & Technology Consultants Pvt. Ltd.
This transmission may (i) be subject to contractual, statutory or other
obligations of confidentiality; (ii) contain "protected health
information " as defined in HIPAA or "non-public personal information "
as defined under data privacy laws; or (iii) be otherwise strictly
confidential. If you are not the intended recipient of this message, you
may not disclose, print, copy or disseminate this information. If you
have received this in error, please reply to the sender only and delete
the message. Unauthorized interception of this e-mail is a violation of
federal law. Diamond's operating subsidiary in North America is Diamond
Management & Technology Consultants NA, Inc.; in the U.K. and Europe,
Diamond Management & Technology Consultants Limited; and in Asia,
Diamond Management & Technology Consultants Pvt. Ltd.
************* IMPORTANT - PLEASE READ ********************
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
| 
