PIN LASTNAME FIRSTNAME COURSECODE EXPENSES CODE EXP EXPSAL 000000020 BELLA MICHAEL . . . . . 000000040 ADAMS RUTH EDP750 3,400.00 EDP750 3,400.00 65,900.00 000000050 ADDAMS PETER UMI720 3,300.00 UMI720 3,300.00 57,400.00 000000060 PATEL DORINA . . . . . 000000070 SANCHEZ EVELYN . . . . . 000000080 SO PAMELA EDP690 3,200.00 EDP690 3,200.00 46,600.00 . SO PAMELA BIT420 3,350.00 BIT420 3,350.00 46,750.00
PIN LASTNAME FIRSTNAME COURSECODE EXPENSES CODE EXP EXPSAL 000000020 BELLA MICHAEL . . AAA 0 62,500.00 000000040 ADAMS RUTH EDP750 3,400.00 EDP750 3,400.00 65,900.00 000000050 ADDAMS PETER UMI720 3,300.00 UMI720 3,300.00 57,400.00 000000060 PATEL DORINA . . AAA 0 55,500.00 000000070 SANCHEZ EVELYN . . AAA 0 83,000.00 000000080 SO PAMELA EDP690 3,200.00 EDP690 3,200.00 46,600.00 . SO PAMELA BIT420 3,350.00 BIT420 3,350.00 46,750.00This message has been edited. Last edited by: <Kathryn Henning>,
MATCH FILE EMPDATA SUM LASTNAME FIRSTNAME SALARY BY PIN RUN FILE TRAINING SUM COURSECODE EXPENSES BY PIN AFTER MATCH HOLD AS TEMPHLD1 OLD END DEFINE FILE TEMPHLD1 CODE/A10 = IF (COURSECODE IS MISSING OR COURSECODE EQ '') THEN 'AAA' ELSE COURSECODE; EXP/D12.2 = IF (EXPENSES IS MISSING OR EXPENSES EQ 0) THEN 0 ELSE EXPENSES; EXPSAL/D12.2 = EXP + SALARY; END TABLE FILE TEMPHLD1 PRINT LASTNAME FIRSTNAME COURSECODE EXPENSES CODE EXP EXPSAL BY PIN WHERE (EXPENSES GT 3000 OR EXPENSES IS MISSING) END
SET ALL = PASS JOIN LEFT_OUTER PIN IN EMPDATA TO ALL PIN IN TRAINING AS JOIN1 TABLE FILE EMPDATA PRINT LASTNAME FIRSTNAME SALARY COURSECODE EXPENSES BY PIN ON TABLE HOLD AS TEMPHLD0 END DEFINE FILE TEMPHLD0 CODE/A10 = IF (COURSECODE IS MISSING OR COURSECODE EQ '') THEN 'AAA' ELSE COURSECODE; EXP/D12.2 = IF (EXPENSES IS MISSING OR EXPENSES EQ 0) THEN 0 ELSE EXPENSES; EXPSAL/D12.2 = EXP + SALARY; END TABLE FILE TEMPHLD0 PRINT LASTNAME FIRSTNAME COURSECODE EXPENSES CODE EXP EXPSAL BY PIN WHERE (EXPENSES GT 3000 OR EXPENSES IS MISSING) END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
SET ALL = PASS JOIN LEFT_OUTER PIN IN EMPDATA TO ALL PIN IN TRAINING AS JOIN1 TABLE FILE EMPDATA PRINT LASTNAME FIRSTNAME COURSECODE EXPENSES COMPUTE CODE/A10 = IF (COURSECODE IS MISSING OR COURSECODE EQ '') THEN 'AAA' ELSE COURSECODE; COMPUTE EXP/D12.2 = IF (EXPENSES IS MISSING OR EXPENSES EQ 0) THEN 0 ELSE EXPENSES; COMPUTE EXPSAL/D12.2 = EXP + SALARY; BY PIN WHERE (EXPENSES GT 3000 OR EXPENSES IS MISSING) END
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |