Thank you, Reeza; however, I am still receiving some errors. After the PROC IMPORT statement, do I need to specify the column names in order for the PROC SQL statement to recognize what I am referencing? After I IMPORT the Excel file, I am then connecting to a DB2 table, is there a join statement that I need to make? The error I am receiving is: ERROR: CLI describe error: [IBM][CLI Driver][DB2] SQL0204N "ZCLMSAS.PAYMENTS1" is an undefined name. SQLSTATE=42704 PROC SQL; CONNECT TO odbc as DB2; CREATE TABLE AllData AS SELECT * FROM CONNECTION TO DB2 ( SELECT DISTINCT DB2TABLE.CUSTOMER.PRODUCT_NUMBER, DB2TABLE.CUSTOMER.YEAR, DB2TABLE.CUSTOMER.CUSTOMER_ID FROM DB2TABLE.CUSTOMER WHERE PRODUCT_NUMBER in (SELECT PRODUCT_NUMBER FROM PAYMENTS1); ) ; DISCONNECT FROM DB2; QUIT;
... View more