Frequently Asked Questions about SAS Software

The following Question & Answer List is based on SAS questions received by the author.

Reading DB2 Tables

Question Answer
How can I convert my SPUFI SQL to run inside SAS Software? Just add the following SAS code before and after your SPUFI code (where the %PUT statement will display the DB2 errors):
PROC SQL;
  CONNECT TO DB2 (SSID=db2x);
  CREATE TABLE work.sasdsn AS
    SELECT * FROM CONNECTION TO DB2
      ( 
       .....SPUFI code........
      );
  %PUT SQLXMSG=&SQLXMSG;
QUIT;

     Back to Main FAQ Menu