Thank you for your reply, Just one more query. Can you provide equivalent SQL query to get the same output.   Thanks in advance. CP. ... View more

Hi,    I think its Many-to-many merging because there are duplicates in both data set. ... View more

Hi, the above mentioned link is good but i am not able to get the exact working of   if jkl and iop   From the above posted code by me.   Thanks in advance. CP. ... View more

Hi KSharp,           Thanks for your reply. It helped. Now, I am able to access the SQL Server but, have one more query. How do i  get the data from specific table of my sql database which i have selected as default database in my DSN.   CODE :   libname MyLib '/folders/myfolders/'; LIBNAME z PCFILES SERVER='MyIP' DSN=SAS USER=sa PASSWORD=database@1     SCHEMA=dbo readbuff=10000 access=readonly; %let path = /folders/myfolders/; libname strat "&path"; proc sql ; connect to PCFILES(SERVER='my IP' DSN=SAS USER=sa PASSWORD=database@1); create table work.stud as select* from connection to PCFILES (PCFILES:: SQLTables "", "", "", ""); quit; proc print data=work.stud; run;   OUTPUT: Attached.   ... View more

Hi,   As suggested by you i have followed the entire procedure as below, LIBNAME z PCFILES SERVER='My IP Address' DSN=SAS USER='My System user' PASSWORD='MySystem password' SCHEMA=dbo readbuff=10000 access=readonly ;   but, I am getting following error :   ERROR: Server is unable to authenticate user credentials. (missing or invalid SERVERUSER=<username> SERVERPASS=<password> on libname statement). ERROR: Error in the LIBNAME statement.   When I searched for this error I was directed to "http://support.sas.com/kb/45/460.html" link. which suggested - setting "Logon as a Batch Job" privilege in the local security policy on the Windows server. Still i am getting the above error.   Pl. Help. Thanks in Advance.     ... View more

Hi ksharp, As per your guidelines I have installed PCFiles and configured the ODBC connection. But, when trying to execute following statements in SAS University Edition libname MyLib '/folders/myfolders/'; LIBNAME MyLib PCFILES SERVER=SERVER DSN=SAS USER='sa' PASSWORD='database@1' ;   I am getting following errors. - Libref MyLib is not assigned. - Error in LIBNAME Statement. - Invalid Option Name. Also the Library created by  "libname MyLib '/folders/myfolders/';" statement disappears. Pl. help.   Thanks, in advance ... View more