BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

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

product Units_Purchased REVENUE
1 1 699.99
1 2 699.99
1 1 699.99
1 1 699.99
2 2 699.99
2 1 699.99
2 2 699.99

how to find the sum of units purchased and teh revenue breakdown by product type?

kindly suggest

regards,
Mark
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Ah, yes, we were here with you back in Feb 2010 - see thread below:

http://support.sas.com/forums/message.jspa?messageID=32184

http://support.sas.com/forums/thread.jspa?messageID=32298

http://support.sas.com/forums/thread.jspa?messageID=33111

http://support.sas.com/forums/thread.jspa?messageID=33390


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.

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?

Scott Barry
SBBWorks, Inc.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1511 views
  • 0 likes
  • 2 in conversation