BookmarkSubscribeRSS Feed
vorkady
Obsidian | Level 7

 

 

We would like to generate user database usage report in SAS Environment. We have SAS Access to Netezza configured to access Netezza database. Is it possible to list such user usage reports using SAS scripts or sourcing SAS logs. Appreciate if you cold advise.

 

 

Thanks in adavance  

1 REPLY 1
Patrick
Opal | Level 21

@vorkady

Using explicit SQL Pass-through you can query directly the database with native Netezza SQL. Not sure what level of information Netezza stores but whatever is there can be queried out of SAS.

Assuming that such information is likely admin level you would of course also need the required privileges for the user connecting to Netezza to have access to such information.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 553 views
  • 0 likes
  • 2 in conversation