Hi All,
i need a help
I have records in the database like this

country_id dealer_cost

1000 200
1000 300
1000 400
1111 200
1111 300
1111 400
2222 200
2222 300
2222 400
i want the records like this each country_id below i want dealer_cost and no space allowed

1000 1111 2222

200 200 200
300 300 300
400 400 400

Thanks in advance.

This message has been edited. Last edited by: Kerry,

SUM DCOST ACROSS COUNTRY maybe? You would have to come up with a recordcounter or some such thing otherwise you end up with just 1 line. Alternatively, upgrade to 77 release, and use the new ACROSSPRT=COMPRESSED setting while doing PRINT ACROSS.

Technique courtesy of an earlier post by Tony A:

TABLE FILE CAR
 LIST DEALER_COST
 BY COUNTRY
 ON TABLE HOLD
END
-*
TABLE FILE HOLD
 SUM DEALER_COST AS ''
 BY LIST NOPRINT
 ACROSS COUNTRY AS ''
END

Solved
Thanks a lot Dan Satchell
The code helped me to solve my problem