The above posters have given you the answer here, in pass-through code the syntax must match the Database syntax requirements. In SAS SQL you can use SAS syntax rules. Maybe if you want to combine the two (and of course, avoiding the * syntax totally, because that would just be guessing!): proc sql; connect to oracle as example (user=xxxxx pw=xxxx path=abcd.xxxxx.com.com); create table work.data as /* This part is processed by SAS and must conform to SAS syntax */ select put(FIELD1,best.) as FIELD1, FIELD2 as FIELD2 from connection to example /* This part is passed to the database and must conform to the database syntax */ ( select field1, field2 from example.Agency_Address where Address_Type = 'PRIMARY' ); quit;
... View more
