All YOUR Questions Answered at
[sas.answers @ Holland Numerics]
WebRing
Sponsored Links for SAS Software Users
Careers, Jobs and Contracts, Services and Products

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
Number of visitors = Counter (since 15th May 2000)

Email: Phil Holland <phil.holland@bcs.org.uk>

Web Design by Holland Numerics

Valid HTML 4.01!