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 2024

Innovate_SAS_Blue.png

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. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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