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,
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.
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.