I there. This is part of an auto process program I created. I recently upgraded from 9.1 to 9.3 and I'm having trouble with some queries that used to work just fine. See below for the query and then below the query I have the Error that now occurs in 9.3. proc sql; create table get_load as SELECT t.DEAL_OPTION_ID as VHET_SUBDEAL_ID, t.CUSTOMER, t.CLOSEDDATE, t.PRODUCT_ID, t.PRODUCT_ATTRIBUTE as COMPONENT_NAME, t.NUM_VALUE, t.BUNDLE_OPTION as BUNDLE_OPTION_FLAG FROM vhet.dh_subdeal_product_structure t WHERE t.TYPE in ('Pricing Component' 'Value Component') and t.PRODUCT_ATTRIBUTE in ('ANNUAL_USAGE' 'TERM_LOAD' 'MARGIN' 'TOTAL_COGS' 'BROKER_FEE' 'CONTRACT_PRICE' 'ANNUAL_PEAK' 'REVENUE' 'PORTAL_FEE') and t.DEAL_OPTION_ID in (&deal_option.) and t.VERSION_CURRENT_YN = 'Y' ORDER BY t.DEAL_OPTION_ID; quit; New Error: ERROR: PROC SQL requires any created table to have at least 1 column. The macro variable &deal_option. doesn't seem to be the problem as that was my first guess. I'm not sure why the columns are now the issue. Just for kicks, this is the macro variable code: proc sql; select vhet_subdeal into: deal_option separated by " " from keep_subdeal_id; quit; Any ideas guys/gals? DH
... View more