BookmarkSubscribeRSS Feed
hopeless
Calcite | Level 5

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.

4 REPLIES 4
AhmedAl_Attar
Rhodochrosite | Level 12

@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

hopeless
Calcite | Level 5
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
AhmedAl_Attar
Rhodochrosite | Level 12

@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

ballardw
Super User

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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 604 views
  • 0 likes
  • 3 in conversation