BookmarkSubscribeRSS Feed
Marilyn
Calcite | Level 5
I used this code to connect to an outside SQL server and it seems to have worked:
libname odbclib odbc noprompt="Driver={SQL Server};
369 Server=10.100.100.100 ;
370 Database=XXXwork;
371 Uid=;
372 Pwd=;"
373 ;
NOTE: Libref ODBCLIB was successfully assigned as follows:
Engine: ODBC
Physical Name:
Can someone tell me how to get table and column names from the server now?
1 REPLY 1
Doc_Duke
Rhodochrosite | Level 12
try this
http://support.sas.com/kb/15/721.html
I searched for on support.sas.com
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1545 views
  • 0 likes
  • 2 in conversation