THANKS! I had tried using the AS verb but it did not run...I have since added the SET command and then amended my table1 amnd table2 routines and now it takes that syntax and allows me to output each individually after the match!!!
HOWEVER..I now have another problem that is somehow a byproduct of all that.
Table1 has 44 records. Table2 had 1.9 million. After the match I should get at most 44 records...in fact I was getting just that until I issues the SET AS NAMES and brought in both fields.
Now I get 1.9M records!!!!
MATCH FILE HTEMP
PRINT HTEMP.HTEMP.GROUP_NUMBER HTEMP.HTEMP.PATIENT_ID HTEMP.HTEMP.PAT_MRN HTEMP.HTEMP.PAT_NM HTEMP.HTEMP.Date_Of_Service HTEMP.HTEMP.TRX_PostingDt HTEMP.HTEMP.TRX_FSC_Number HTEMP.HTEMP.CurrentFSC HTEMP.HTEMP.TXPAYCD1
PRINT HTEMP2.HTEMP2.TRX_PAYMENT_AMOUNT HTEMP2.HTEMP2.TXPAYCD2
AFTER MATCH HOLD AS HTEMP3 OLD-AND-NEW
TABLE FILE HTEMP3
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
Only difference I can see is the references to: TXPAYCD1
Windows, All Outputs