https://communities.sas.com/t5/SAS-Procedures/proc-tabulate/m-p/51914#M14263 Ah, yes, we were here with you back in Feb 2010 - see thread below:<BR /> <BR /> <A href="http://support.sas.com/forums/message.jspa?messageID=32184" target="_blank">http://support.sas.com/forums/message.jspa?messageID=32184</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=32298" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=32298</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=33111" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=33111</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=33390" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=33390</A><BR /> <BR /> <BR /> To MarkC: it would be useful to reveal what you might expect to see as output and possibly even contribute what SAS code you have used/attempted in the past, relative to the current post/query. It would also help forum readers/contributors determine just how much effort you have put into researching a forum post thus far.<BR /> <BR /> For PROC TABULATE and your post, have you looked at using SUM -- which was revealed in at least one of the prior post threads listed above?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sun, 18 Jul 2010 14:55:49 GMT sbb 2010-07-18T14:55:49Z https://communities.sas.com/t5/SAS-Procedures/proc-tabulate/m-p/51913#M14262 Hi, <BR /> <BR /> in the proc tabulate i read some articles but all deal with getting the N,Pctn mainly etc. for a variable. I wnat to find out the number of units of two differne goods purchased,say X and Y, a sample of the excel file is <BR /> <BR /> product Units_Purchased REVENUE<BR /> 1 1 699.99<BR /> 1 2 699.99<BR /> 1 1 699.99<BR /> 1 1 699.99<BR /> 2 2 699.99<BR /> 2 1 699.99<BR /> 2 2 699.99<BR /> <BR /> how to find the sum of units purchased and teh revenue breakdown by product type?<BR /> <BR /> kindly suggest <BR /> <BR /> regards,<BR /> Mark Sun, 18 Jul 2010 05:26:29 GMT https://communities.sas.com/t5/SAS-Procedures/proc-tabulate/m-p/51913#M14262 deleted_user 2010-07-18T05:26:29Z https://communities.sas.com/t5/SAS-Procedures/proc-tabulate/m-p/51914#M14263 Ah, yes, we were here with you back in Feb 2010 - see thread below:<BR /> <BR /> <A href="http://support.sas.com/forums/message.jspa?messageID=32184" target="_blank">http://support.sas.com/forums/message.jspa?messageID=32184</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=32298" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=32298</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=33111" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=33111</A><BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=33390" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=33390</A><BR /> <BR /> <BR /> To MarkC: it would be useful to reveal what you might expect to see as output and possibly even contribute what SAS code you have used/attempted in the past, relative to the current post/query. It would also help forum readers/contributors determine just how much effort you have put into researching a forum post thus far.<BR /> <BR /> For PROC TABULATE and your post, have you looked at using SUM -- which was revealed in at least one of the prior post threads listed above?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sun, 18 Jul 2010 14:55:49 GMT https://communities.sas.com/t5/SAS-Procedures/proc-tabulate/m-p/51914#M14263 sbb 2010-07-18T14:55:49Z