Hi,
I have a list of items which have prices for the last three months. Now i need to compare the prices for each iten between these three months and i need to find if the price has Increased or Decreased or Nochnage of that item.
Is there any way to achive this.
Thanks
Nag

NAG,

Try the following:

TABLE FILE CAR
PRINT SALES
COMPUTE UPDWN/A3=IF (SALES GT LAST SALES) THEN 'UP' ELSE 'DWN';
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
END

Can you describe what your MFD looks like?

Another quick and d!rty example:

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
-RUN

TABLE FILE GGORDER
SUM QUANTITY AS 'ORDER'
BY PRODUCT_CODE
ACROSS ORDER_DATE
WHERE ORDER_DATE GE '10/01/97'
WHERE ORDER_DATE LE '12/01/97'
ON TABLE HOLD AS HORDER
END
-RUN

TABLE FILE HORDER
PRINT 
E02
E03
COMPUTE DIFF1/D6 = E03 - E02;
E04
COMPUTE DIFF1/D6 = E04 - E03;
END
-RUN

Hi
here is the example of my data

Item Month Price
A1 1 10
A1 2 7.5
A1 3 5
A2 1 5
A2 2 6
A2 3 10
A3 1 10
A3 2 10
A3 3 10
. . .
. . .
. . .
. . .
. . .
F3 3 10

Here my ItemImproving is: A2
ItemDecresing is: A1
ItemNochange is: A3

Thanks
Nag

Nag, take a look at my example - it should work for you.

Nag: If A1 in month 3 was 11 what would you do?

Hi act 12345

That record will be ignored

quote:

Item Month Price
A1 1 10
A1 2 7.5
A1 3 5
A2 1 5
A2 2 6
A2 3 10
A3 1 10
A3 2 10
A3 3 10
. . .
. . .
. . .
. . .
. . .
F3 3 10

Here my ItemImproving is: A2
ItemDecresing is: A1
ItemNochange is: A3

quote:

Nag: If A1 in month 3 was 11 what would you do?

quote:

Hi act 12345
That record will be ignored

So from what you say, then

Item Month Price
A1 1 10
A1 2 7.5
A1 3 11
A2 1 5
A2 2 6
A2 3 10
A3 1 10
A3 2 10
A3 3 10
. . .
. . .
. . .
. . .
. . .
F3 3 10

ItemImproving is: A2
ItemNochange is: A3
ItemIgnore: A1

That I don't understand.