topic Re: Netezza engine cannot be found in SAS Programming

Netezza engine cannot be found

hopeless — Wed, 19 Jul 2023 10:23:11 GMT

I just got new computer and I installed SAS eg 8.3 with fresh license. I'm trying to run old code, but apparently I cannot connect to netezza. I can't find any solution to this

ERROR: The NETEZZA engine cannot be found.
ERROR: Error in the LIBNAME statement.

Re: Netezza engine cannot be found

AhmedAl_Attar — Wed, 19 Jul 2023 11:17:03 GMT

@hopeless

Run the following to tell you which SAS products/modules you have license for and which of them have been installed on your machine

/* Display Licensed products information */
Proc setinit; run;

/* Display which licensed product have been installed */
proc product_status; run;

Hope this helps,

Ahmed

Re: Netezza engine cannot be found

hopeless — Wed, 19 Jul 2023 11:27:48 GMT

Product expiration dates:
---Base SAS Software 31MAY2024
---SAS/GRAPH 31MAY2024
---SAS/FSP 31MAY2024
---SAS/AF 31MAY2024
---SAS/CONNECT 31MAY2024
---SAS/Secure 168-bit 31MAY2024
---SAS/Secure Windows 31MAY2024
---SAS Enterprise Guide 31MAY2024
---SAS/ACCESS Interface to PC Files 31MAY2024
---SAS/ACCESS Interface to ODBC 31MAY2024
---SAS Workspace Server for Local Access 31MAY2024
---SAS/ACCESS to Postgres 31MAY2024

30
2 The SAS System 13:36 Wednesday, July 19, 2023

31 /* Display which licensed product have been installed */
32 proc product_status; run;

For Base SAS Software ...
Custom version information: 9.4_M2
Image version information: 9.04.01M2P072314
For SAS/GRAPH ...
Custom version information: 9.4_M2
For SAS/FSP ...
Custom version information: 9.4_M2
For SAS/AF ...
Custom version information: 9.4_M2
For SAS/CONNECT ...
Custom version information: 9.4_M2
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M2
For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M2

Re: Netezza engine cannot be found

AhmedAl_Attar — Wed, 19 Jul 2023 11:39:35 GMT

@hopeless

As you can see from the output you got, SAS/ACCESS to Netezza is not licensed! hence your Libname Error message.

You may try the SAS/ACCESS Interface to ODBC to connect to Netezza, but that may not yield the best of results/performance. It's something rather than nothing, I guess

Re: Netezza engine cannot be found

ballardw — Wed, 19 Jul 2023 14:19:58 GMT

If you previously had access to Netezza then it appears the installation used for you new computer is not the same as previously used. You might check with who did the install. Also the version of SAS you show, 9.4_M2 is more than a couple of years old. The latest version is 9.4_M8.