I'm trying to use proc sql to connect to a db2 database. For some reason SAS tells me that in the statement connect to db2 (ssid=somessid); the ssid= option is illegal. I also tried to give SAS the option options DB2SSID=somessid; but I also get an error about the DB2SSID option being unrecognized. The code works fine in normal SAS. How do I fix this?
... View more