Hi Everyone,
I need to tabulate sales of some brands something like this
sales
Brand A(Excluding 0) 124
Brand B 250
Brand C 350
Just wondering, is there a way to calculate sum sales for brand "A" excluding zero values, while other brands including everying.
Any help regarding this will be highly appreciated.
Regards
Perfect.
You should be able to use a WHERE statement like this:
where (brand ne 'A') or (brand='A' and sales > 0);
Why will it matter? The SUM including 0 is the same as the SUM excluding 0.
Thanks Astounding - I am looking for average sales after this step and will exclude zero values in avg calculation
One way is to use
WHERE sales > 0;
in your code. However the count (denominator) may not be what you want if you are doing anything else in the same procedure call.
Otherwise you may get into some preprocessing.
Thanks ballardw - I just want to change denominator for brand 'A' excluding number of zeros and keep full count in denominatior for other variables in a single run of proc tabulate syntax. I was thinking a way to adjust this in proc tabulate syntax but seems like I need to do some preprocessing before tabulate.
It may be possible, but we need to know what your data looks like. Give us a sample of 10 observations and the key variables (anywhere from 2 to 5 variables, depends on what the data looks like ... just include whatever you think would be relevant).
Please see below a snapshot of the data
Brand Province txn_date Sales
A AA 2015-10-01 12
A AA 2015-10-09 0
B AA 2015-10-09 25
B BB 2015-10-22 0
A CC 2015-10-25 26
A CC 2015-10-26 0
A DD 2015-10-26 0
A EE 2015-10-30 23
B AA 2015-10-30 15
Perfect.
You should be able to use a WHERE statement like this:
where (brand ne 'A') or (brand='A' and sales > 0);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: