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! ... View more

Hello,   I've read a lot about implicit and explicit pass-through facility in SAS. I'm wondering if implicit pass through only applies for proc sql? Or does it also apply when writing data steps? All the examples I saw so far regarding implicit pass-through are proc sqls. Can you clear this up for me?   Thanks ... View more

I have an SQL pass through written in SAS that basically returns a limit of 100 records from a table stored in Netezza. I would like to also return 100 records from another table in Netezza without having to re-connect. Here's what I got:   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; How can I select from table2 within the same connection? I tried doing this:   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;), (SELECT * FROM SCHEMA.table2 LIMIT 100;); quit; But I get a syntax error. Any help would be great! ... View more

When I load SAS files to Netezza, SAS chooses it's own data types which will affect the performance in Netezza when querying through a really large table because sometimes I can store a column as a BYTEINT in Netezza but when importing it from SAS, it'll store it as Character Varying (1). So instead I tried to create the table in Aginity and than insert the SAS file into the table through SAS.   This is my code to import SAS to Netezza:   LIBNAME ECLIB000 "\\Path\To\SASTables"; libname sdf odbc noprompt="server=xxxx; DRIVER={NetezzaSQL}; port=xxxx; database=xxx; username=xxxx; password=xxxx;"; proc sql; INSERT INTO sdf.NetezzaTable (bulkload=YES) SELECT * FROM ECLIB000.SASTable; quit; With doing this, I get errors like: ERROR: Value 2 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name   And I'm guessing it's because it's trying to insert a value that has a different data type than the one I created. How can I insert into the Netezza table using the data types I created in Aginity? Or is there a better way to doing this?   Thanks!   ... View more