BookmarkSubscribeRSS Feed
esbabu
Calcite | Level 5

Wondering if it is possible to use ssh keys in place of password in a sas libname statement?

Something like one uses to connect remotely to a linux machines using ssh

3 REPLIES 3
SASKiwi
PROC Star

What LIBNAME engine does this relate to? By default if you don't specify an engine it will default to V9, to access or create SAS V9 datasets in a SAS library. If this is the engine you are referring to, then any connection to a remote server folder needs to be done in the SAS server OS outside of SAS.  

esbabu
Calcite | Level 5

Thank you @SASKiwi for the reply.

What I was exploring is the ability to use  public/private key combination in  a libname statement (for  example  to  MySQL, snowflake, data bricks using odbc or SAS Access engines ) instead of username /password combination.
I agree the database too should support it.

Kurt_Bremser
Super User

When you define a LIBNAME to a remote database, SAS uses the database's client (which must be installed and configured on the SAS computer). How this client uses encryption in the connection to the DB server must be configured in the client, not in SAS. In SAS you only provide the credentials for the DB, and those are user/password.

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!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 156 views
  • 0 likes
  • 3 in conversation