i**o
发帖数: 9 | 1 Sorry for writing in English - I can't type Chinese font in company PC.
I was trying to access microsoft SQL server using SAS oledb engine. The SAS
statement I use was "libname mydb oledb;". After running the statement, I
can see that a library 'mydb' was created in the library folder. However
that library folder was empty in the explorer window. I can still pull out
data in SAS since I know the name of the tables from microsoft SQL
management studio.
Can somebody advise me how I can directly see all my tables directly from
SAS explorer windows?
Thank you very much! | s******y
发帖数: 352 | 2 下此问问题时，准备点包子，你就1个为币。唉。
add option schema=yourschema in your libname statment.
大多数时，schema=DBO 就行了。 如果不是default DBO, ask the Admin for the
name of schema you are trying to access.
SAS
【在 i**o 的大作中提到】
: Sorry for writing in English - I can't type Chinese font in company PC.
: I was trying to access microsoft SQL server using SAS oledb engine. The SAS
: statement I use was "libname mydb oledb;". After running the statement, I
: can see that a library 'mydb' was created in the library folder. However
: that library folder was empty in the explorer window. I can still pull out
: data in SAS since I know the name of the tables from microsoft SQL
: management studio.
: Can somebody advise me how I can directly see all my tables directly from
: SAS explorer windows?
: Thank you very much!
| i**o
发帖数: 9 | 3 Thank you, Smileguy. I will save some Baozi next time. :-) | i**o
发帖数: 9 | |
|
