Supposed I have data that gets returned to me as a records as following:

  
CAR 		SALES1		SALES2		SALES_DATE_1		SALES_DATE_2
Jaguar		100000		150000		01/01/2008		01/01/2009
BMW		200000		200000		01/01/2008		01/01/2009

Would there be a way for me to take this data to produce a report such as:

 

CAR: JAGUAR

			SALES
01/01/2009		150000
01/01/2008		100000


CAR: BMW
			SALES
01/01/2009		200000
01/01/2008		200000

I'd prefer not to do this with all the data in a subhead or subfoot (which I know I can do). I'm looking to try to get real columns out of this if possible.

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

Print the columns as CAR, SALES1, SALES_DATE_1, SALES2, SALES_DATE_2 and hold format alpha.

Create an alternate master for the hold file using the OCCURS clause and then filedef this master to your hold file.

Your master would look something like this:

FILENAME=CARSALES, SUFFIX=FIX
SEGNAME=CARS,SEGTYPE=S0
FIELD=CAR, ALIAS=, FORMAT=A10, ACTUAL=A10,$
SEGNAME=SALES,OCCURS=n,PARENT=CARS,$
FIELD=SALES, ALIAS=, FORMAT=I8, ACTUAL=A8,$
FIELD=SLSDT, ALIAS=, FORMAT=YYMD, ACTUAL=A8,$

Note: You will have to adjust the formats for your own data.
Note 2: n will be the max number of occurs or can be VARIABLE.

Then you can say:

TABLE FILE CAR SALES
SUM SALES
BY CAR
BY SLSDT
END

Thanks!

The easiest way would be to read the data twice, creating HOLD files with renamed columns, something like this:

SET ASNAMES=ON

TABLE FILE CAR
PRINT
LENGTH AS 'DIM'
COMPUTE DIMX/A10 = 'LENGTH';
BY MODEL
ON TABLE HOLD AS H001
END

TABLE FILE CAR
PRINT
WIDTH AS 'DIM'
COMPUTE DIMX/A10 = 'WIDTH';
BY MODEL
ON TABLE HOLD AS H002
END

TABLE FILE H001
PRINT 
DIM
DIMX
BY MODEL

MORE
FILE H002
END

Francis,

That works really nicely.

Thanks so much.