plz help me wit the code to display highest value as column total

This message has been edited. Last edited by: <Emily McAllister>,

Please, give us more information.

If I understand properly what you're asking for, it may not be the only way, but this is one

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
ON TABLE HOLD AS TMP FORMAT FOCUS
END
-RUN

TABLE FILE TMP
SUM RETAIL_COST
BY HIGHEST RETAIL_COST NOPRINT
BY COUNTRY
END
-RUN

Please, next time be more detailed and if possible, include a sample of your need; it helps us to understand you.

He wants, the way I understand it, to display the max value of a column on the column-total, instead of the column-total. The easiest way that somewhat resembles this would be:

TABLE FILE CAR
SUM MAX.DEALER_COST
ON TABLE HOLD AS TKHOLD FORMAT ALPHA
END
-RUN

-READ TKHOLD, &DEALER_COST
-RUN

TABLE FILE CAR
PRINT *
FOOTING
"Highest Value: &DEALER_COST"
ON TABLE SET STYLE *
TYPE=FOOTING, JUSTIFY=RIGHT,$
END
-RUN

The harder way would be to make multiple holdfiles, and computing everything yourself...

TABLE FILE CAR
SUM MAX.DEALER_COST NOPRINT
PRINT DEALER_COST
ON TABLE SUBFOOT
"<MAX.DEALER_COST"
END