DEFINE FILE CAR MYFORMAT/A8=DECODE COUNTRY ('ENGLAND' 'P15.2C' 'JAPAN' 'P15' ELSE 'P15.2M'); END TABLE FILE CAR SUM SALES/MYFORMAT BY COUNTRY END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
TABLE FILE CAR SUM RCOST DCOST COMPUTE PCT/D12.2 = ((RCOST-DCOST)/DCOST)*100; NOPRINT FMT/A8 = IF INT(PCT) EQ PCT THEN 'F3' ELSE 'F4.1'; NOPRINT PCT/FMT BY COUNTRY BY CAR ENDHowever that right justifies and looks bad IMO.
TABLE FILE CAR SUM RCOST DCOST COMPUTE PCT/D12.2 = ((RCOST-DCOST)/DCOST)*100; NOPRINT ALPHA1/A6 = FTOA(PCT,'(D5.1)','A6'); NOPRINT ALPHA2/A6 = FTOA(PCT,'(D5)','A6'); NOPRINT DISPLAY/A6 = IF INT(PCT) EQ PCT THEN ALPHA2 ELSE ALPHA1; BY COUNTRY BY CAR