Prev: Selecting dates in a period. Was RE: new joinee
Next: Counting
From: mark on 9 Mar 2010 10:26
Hello I use the code below :

proc tabulate data=period;
class A B;
var Y;
table period*(B all='Subtotal')
all='Total for All goods sold'*f=dollar12.,
all='Profits from both goods'*profit=' '*sum=' '
/ rts=25;
title 'Profits from each good';
title2 '(Profits in Dollars)';
RUN;

when i run the code above it works fine but the problem is that the
revbues from both goods sold give me an aggregate figure and the goods
have two categories - C and D and I want that the profit breakdown
from both the goods.

Kindly guide as to what change i need in the code above so that I've a
breakdown in the profit from the two goods type - C and D

Mark
From: Joe Matise on 9 Mar 2010 11:36
Your use of letters instead of words is confusing but it sounds like perhaps
you need Y to be also a class variable (in which case you can't do sums on
it)? Which variable is 'goods'?

-Joe

On Tue, Mar 9, 2010 at 9:26 AM, mark <mark.chase91(a)yahoo.in> wrote:

> Hello I use the code below :
>
> proc tabulate data=period;
> class A B;
> var Y;
> table period*(B all='Subtotal')
> all='Total for All goods sold'*f=dollar12.,
> all='Profits from both goods'*profit=' '*sum=' '
> / rts=25;
> title 'Profits from each good';
> title2 '(Profits in Dollars)';
> RUN;
>
> when i run the code above it works fine but the problem is that the
> revbues from both goods sold give me an aggregate figure and the goods
> have two categories - C and D and I want that the profit breakdown
> from both the goods.
>
> Kindly guide as to what change i need in the code above so that I've a
> breakdown in the profit from the two goods type - C and D
>
> Mark
>
 | 
Pages: 1
Prev: Selecting dates in a period. Was RE: new joinee
Next: Counting