|
|
|
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;
|
