topic Proc Tabulate in SAS Programming

Proc Tabulate

stat_sas — Mon, 23 Nov 2015 16:32:35 GMT

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

Re: Proc Tabulate

Astounding — Mon, 23 Nov 2015 16:46:13 GMT

Why will it matter? The SUM including 0 is the same as the SUM excluding 0.

Re: Proc Tabulate

stat_sas — Mon, 23 Nov 2015 16:59:22 GMT

Thanks Astounding - I am looking for average sales after this step and will exclude zero values in avg calculation

Re: Proc Tabulate

pearsoninst — Mon, 23 Nov 2015 17:11:09 GMT

I am not sure if we can , as Astounding said "Why will it matter? " my question is if i need to exclude values less then 5 can we do it in Proc Tabulate.

Re: Proc Tabulate

ballardw — Mon, 23 Nov 2015 17:52:00 GMT

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.

Re: Proc Tabulate

stat_sas — Mon, 23 Nov 2015 18:23:17 GMT

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.

Re: Proc Tabulate

Astounding — Mon, 23 Nov 2015 18:25:47 GMT

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).

Re: Proc Tabulate

stat_sas — Mon, 23 Nov 2015 19:01:58 GMT

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

Re: Proc Tabulate

Astounding — Mon, 23 Nov 2015 19:05:41 GMT

Perfect.

You should be able to use a WHERE statement like this:

where (brand ne 'A') or (brand='A' and sales > 0);