I am trying to establish a connection to MS SQL server databse from a SAS program using a standard ODBC driver The code: libname testdb odbc noprompt="server=serv1;DRIVER=SQL Server;Trusted Connection=yes" DATABASE=mydb schema=dbo PRESERVE_TAB_NAMES=YES; This works without problems, however the table names inside a dataset are strangely encoded: I don't know is it because of the dirve or am i doing something wrong? If i try to print the table data like proc print data=testdb.Step;
run; This produces the error: proc print data=testdb.Step; ERROR: File TESTDB.Step.DATA does not exist. 25 run;
... View more
