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.
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
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
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.