I have a dataset (dataset1) with 10 columns. I would like to use one of the columns (ID) as an input in proc sql to query a cloud server to retrieve more info. This is what I have so far, but it doesn't work: PROC SQL; CONNECT TO ODBC (DSN='database_name'); CREATE TABLE WORK.new_table AS SELECT * FROM connection to odbc (select * from cloud_table where (col_name IN (SELECT COL1 FROM WORK.DATASET1)) ); disconnect from odbc; quit; If I were to write exact same proc with each uniqueID in ' ' then it works, for example: PROC SQL; CONNECT TO ODBC (DSN='database_name'); CREATE TABLE WORK.new_table AS SELECT * FROM connection to odbc (select * from cloud_table where (col_name IN ('id1', 'id2', 'id3', etc. ) ) ); disconnect from odbc; quit;
... View more