How to create a SAS table from query

jim_toby — Wed, 19 Dec 2018 15:25:33 GMT

I want to query through a table stored on the Netezza server and generate a SAS table out of it.

Here is my query:

proc sql; 
connect to odbc as odbcCon 
(noprompt='Driver={NetezzaSQL}; server=xxxxxx; port=xxxxx; database=xxx; username=xxxx; password=xxxxx;'); 
select * from connection to odbcCon 
(SELECT *
  FROM SCHEMA.table1
 LIMIT 100;); 
quit;

It's an sql pass through. How can I generate a SAS table from the result of the query? Thanks in advance!

Re: How to create a SAS table from query

kiranv_ — Wed, 19 Dec 2018 15:47:21 GMT

All you need to do is add a create table statement

proc sql; 
connect to odbc as odbcCon 
(noprompt='Driver={NetezzaSQL}; server=xxxxxx; port=xxxxx; database=xxx; username=xxxx; password=xxxxx;'); 
create table work.sastable as 
select * from connection to odbcCon 
(SELECT *
  FROM SCHEMA.table1
 LIMIT 100;); 
quit;

topic How to create a SAS table from query in SAS Programming

How to create a SAS table from query

Re: How to create a SAS table from query