Hello, below is a sample query that runs in DB2. However, all of a sudden, I am now getting a prepare error and cannot figure out why. Any ideas? The pasted code can be found below:   /*%put &FAXES;*/ %let FAXES=&FAXES, 1, 2; /*%put &FAXES;*/ PROC SQL; (SELECT a.CAR_ID, c.CAR_NAME AS NAME, e.MAKE||' '||e.MODEL AS MAKE_MODEL FROM OWNER.FACTORY b LEFT JOIN OWNER.CARS a ON b.KEY=a.KEY LEFT JOIN OWNER.STATUSES c ON b.TIME_ID =c.TIME_ID LEFT JOIN OWNER.DRIVERS e ON b.NAME=e.NAME INNER JOIN (SELECT ENTITY, max(TIME) AS TIMESTAMP FROM OWNER.FACTORY WHERE FAX_ID='Fax' AND ENTITY IN(&FAXES) AND TIMESTAMP>DATE-60 GROUP BY ENTITY) d ON b.KEY=d.ENTITY AND b.TIMESTAMP=d.TIMESTAMP WHERE b.FAX_ID='Fax' AND b.KEY IN(&FAXES) AND b.TIMESTAMP>DATE-60); Quit; ... View more