What are neccessary step to create a SAS library for microsoft server ?
I have created one but it is giving following error :-
ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.
What does it mean or what are the possible reason for above error?
Many thanks in advance
I have followed below link and able to create library.
http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/64205/PDF/default/config.pdf
There are many examples in the documentation/papers on how to do this.
What have you tried? The error alone is not enough to understand your situation.
i have created first data connection through SAS SMC and then created new library using SAS SMC .
Is this working or not ?
Can you suggest how should i proceed ?
First step: make it work from outside SAS first (but from the same host), i.e. using Excel.
I find it easiest to get a LIBNAME statement working successfully first and then use that as my basis to create an SMC data library. Please post the LIBNAME statement that is giving you the error.
I have tried to run below libname :-
LIBNAME SAS_MS SQLSVR datasrc="172.31.15.3:1433/JXX_XXX_EXT" SCHEMA=DBO user='misXXX' password='XXXXX';
and i have added entry for sqlsvr in odbc.ini and then tried below libname:-
LIBNAME SAS_MS SQLSVR Datasrc=MSDATA_PROD SCHEMA=DBO AUTHDOMAIN="AUTH_MSSQL" ;
Am i doing right or not ?
I have followed below link and able to create library.
http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/64205/PDF/default/config.pdf
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.