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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.