In BATCH Focus, I am outputting a file through the ON TABLE SAVE AS process, and happen to be using a COMPUTE statement to calculate percentages at total time. My output is a summarized file, however, the output file now also contains the fields used to calculate the percentages, when what I want is only the new calculated field. Is there a way to keep these field from being in the output file?

Focus:
SUM ARS_AIN
M_NAME M_FNM ARS_SELL_STR
ARS_HOME_STR
WKC_SRT COMPUTE PEN/P7.2 = ARS_DDS_SLS_AMT * 100 / ARS_SLS_AMT;
ARS_APPS_PROCESSED COMPUTE HRS_APP/P5 = ARS_SELLING_HRS / ARS_APPS_PROCESSED;
ARS_DDS_SLS_UNIT
ARS_SLS_UNIT
BY ARS_SELL_STR NOPRINT
BY WKC_SRT NOPRINT NOPRINT
BY ARS_AIN NOPRINT NOPRINT
ON TABLE SAVE AS IPSRECAP

Output file:
ARS_AIN ARS_AIN A9 9
M_NAME M_NAME A20 20
M_FNM M_FNM A12 12
ARS_SELL_STR ARS_SELL_STR A4 4
ARS_HOME_STR ARS_HOME_STR A4 4
WKC_SRT A4 4
ARS_DDS_SLS_AMT ARS_DDS_SLS_> P13.2 13
ARS_SLS_AMT ARS_SLS_AMT P13.2 13
PEN P7.2 7
ARS_APPS_PROCESSED ARS_APPS_PRO> P8 8
ARS_SELLING_HRS ARS_SELLING_> P9.2 9
HRS_APP > P5 5
ARS_DDS_SLS_UNIT ARS_DDS_SLS_> P8 8
ARS_SLS_UNIT ARS_SLS_UNIT P8 8

Thanks,
Jackie

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

This is a very basic question, add the following to your code:

SET HOLDLIST=PRINTONLY

or

ON TABLE SET HOLDLIST PRINTONLY

Thank you! I try to look in the 'Creating Reports' manual before posting a question, but wasn't sure where to look.

I appreciate your assistance.

Jackie