cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SASWayne
‎02-17-2025
  • 66 Posts
  • 52 Likes Given
  • 4 Solutions
  • 21 Likes Received

SAS/ACCESS to JDBC on AIX Installation

by Quartz | Level 8 in Administration and Deployment
‎02-17-2025 01:56 AM
‎02-17-2025 01:56 AM
We recently installed SAS/ACCESS to JDBC engine into our existing SAS 9.4M7 grid deployed on AIX. Post installation, the new engine does not show up in the newly generated deployment registry report. We ran a test JDBC libname statement through SAS NODMS which throws JDBC engine not found error. Could someone help with this issue please? ... View more

SAS AML Installation documentation

by Quartz | Level 8 in Administration and Deployment
‎09-13-2023 07:34 AM
‎09-13-2023 07:34 AM
Hello -   I'm looking for steps to deploy anti-money laundering 8.3 solution on SAS Viya and having hard time with finding any documentation on it.   Can someone please help with the AML deployment document URL or is there a specific process to get that documentation (as some AML documentation are restricted)?   Thanks in advance! ... View more

Choosing between SAS Grid and SAS Viya

by Quartz | Level 8 in New SAS User
‎12-12-2022 11:00 PM
‎12-12-2022 11:00 PM
Hello - Since SAS Viya 4.x and SAS Grid 9.4 M7 both have similar attributes such as scalability, HA, cloud deployable, Parallelism (SAS Viya - Data & SAS Grid - Task) etc., How does an organization that's new to SAS choose between SAS Viya or Grid? If the organization is having an existing SAS 9.4 M7 or 9.4Mx grid, what are the advantages of moving them to SAS Viya 4.x? Thanks in advance! ... View more

Re: Libname statement for SAS/ACCESS to Snowflake

by Quartz | Level 8 in SAS Programming
‎08-20-2022 03:22 AM
1 Like
‎08-20-2022 03:22 AM
1 Like
I have used sasiosnf with SAS 9.4M7 and it works, not tried 'snow' yet. I think it'll give it a shot, will post the results later. ... View more

Libname statement for SAS/ACCESS to Snowflake

by Quartz | Level 8 in SAS Programming
‎08-19-2022 05:24 PM
‎08-19-2022 05:24 PM
Hello Experts, I'm trying to understand the difference between using 'snow' and 'sasiosnf' in the place of engine in the libname statement to connect with Snowflake using SAS/ACCESS to Snowflake. Ex- libname snowlib snow dsn=snowprod; libname snowlib sasiosnf dsn=snowprod; Could someone help me with the difference please? Thanks! ... View more

Re: SAS 9.4 M7 and Azure Delta Lake

by Quartz | Level 8 in Administration and Deployment
‎08-19-2022 09:44 AM
‎08-19-2022 09:44 AM
We were able to achieve this using Databricks through ODBC. Also, there was hint from SAS TS that support to read Parquet files might be available from SAS 9.4M8. If it happens, hopefully we should be able to directly access Delta lake. Steps, 1. Installed ODBC Driver Manager 2. Installed ODBC Driver for Databricks. 3. Added DSN information into odbc.ini 4. Added ODBCINI env variable into <sashome>/SASFoundation/9.4/bin/sasenv_local 5. Validated the connection using isql command. 6. Setup DB connectivity at SAS Metadata and other stuff and tested connectivity from SAS clients.  ... View more

Re: SAS Personal Login Manager To Use With SAS EG

by Quartz | Level 8 in Administration and Deployment
‎08-10-2022 02:43 AM
‎08-10-2022 02:43 AM
@Nigel_Pain @ChrisHemedinger @SASKiwi Any idea if SAS Personal login manager is a paid software or a free one? ... View more

SAS 9.4M7 Snowflake Database Server Creation

by Quartz | Level 8 in Administration and Deployment
‎08-09-2022 03:14 AM
‎08-09-2022 03:14 AM
Hello Folks, I'm trying to setup Snowflake database server in SAS9.4M7 environment using SAS Management console. While doing it, I cannot find "Snowflake server" under new server wizard in SMC, neither "Snowflake library" under new library wizard. We have SAS/Access to Snowflake licensed and I can confirm the same using proc setinit.  Is there a way to bring up "Snowflake Server" into the list of Database servers in new server wizard? The version of SMC I currently use is for SAS 9.4M3, is this the reason that I'm not able to find Snowflake server?   Thanks! ... View more

Re: SAS Personal Login Manager To Use With SAS EG

by Quartz | Level 8 in Administration and Deployment
‎08-02-2022 08:14 AM
‎08-02-2022 08:14 AM
You're right, I couldn't find it either from within SAS EG. However SAS EG Explorer is there in the SAS EG's installation directory. ... View more

Re: SAS Personal Login Manager To Use With SAS EG

by Quartz | Level 8 in Administration and Deployment
‎08-02-2022 07:05 AM
‎08-02-2022 07:05 AM
Thanks! Wondering if there is a way to managing the logins from within SAS EG itself? ... View more

Re: SAS Personal Login Manager To Use With SAS EG

by Quartz | Level 8 in Administration and Deployment
‎08-02-2022 05:56 AM
‎08-02-2022 05:56 AM
@AnandVyas    Any idea where to find this option in SAS EG 8.3? I could not find SAS Enterprise Guide Explorer under tools menu.   ... View more

Re: SAS connectivity to snowflake using JDBC

by Quartz | Level 8 in Administration and Deployment
‎08-02-2022 04:09 AM
‎08-02-2022 04:09 AM
That helps, thanks so much @gwootton ! ... View more

SAS connectivity to snowflake using JDBC

by Quartz | Level 8 in Administration and Deployment
‎07-29-2022 04:54 AM
‎07-29-2022 04:54 AM
Hello Folks, I'm connecting SAS and Snowflake using JDBC. We have licensing for SAS/ACCESS to JDBC. The steps would be - 1. install JAVA or OpenJDK 2. Put the JDBC driver for Snowflake (JAR file) in the compute server 3. Setup Snowflake DB server, libraries, authdomain etc. in metadata and use them or 4. use the libname, where driverclass=snowflake-jdbc-driverclass-string classpath=path-to-jar-file-in-server url="jdbc:snowflake:url" and other usual options.   are the above steps correct?   I'm also getting confused with SAS Driver for JDBC. Could someone help me with what it is about? Do I need to use it for SAS and Snowflake connection using JDBC?   Thanks in advance! ... View more

Re: SAS 9.4 M7 and Azure Delta Lake

by Quartz | Level 8 in Administration and Deployment
‎07-04-2022 10:11 PM
1 Like
‎07-04-2022 10:11 PM
1 Like
Same thoughts here! I was going through the below. https://databricks.com/blog/2022/03/16/how-to-speed-up-data-flow-between-databricks-and-sas.html I'll keep this thread open and add the steps here after establishing connectivity. thank you for looking into this! ... View more

Re: SAS 9.4 M7 and Azure Delta Lake

by Quartz | Level 8 in Administration and Deployment
‎07-04-2022 02:58 AM
‎07-04-2022 02:58 AM
Good day @SASKiwi - Thanks for responding!   I mean Azure Delta lake.... for reference - https://docs.microsoft.com/en-us/azure/databricks/delta/ and https://delta.io/   We do have SAS/ACCESS to ODBC licensed and trying to set this up on SAS 9.4M7 grid environment (Linux) hosted on Azure.   What I understood about delta lake is that delta tables stored in delta lakes are read and transformed by interfaces such as Azure Databricks, Apache Spark, Azure Synapse etc., I'm wondering if SAS could do the same as these Interfaces. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-17-2025 06:22 AM
Group Hubs for SASWayne
View All
Likes given to
View All
Likes from
Quick links