BookmarkSubscribeRSS Feed

[SAS 활용 FAQ] CAS LIBRARY의 table 목록이 보이지 않는데 어떻게 조치해야 하나요?

Started ‎10-05-2021 by
Modified ‎10-05-2021 by
Views 312

[상세내용]

casutil 프로시저를 실행하면 아래와 같은 오류가 발생했습니다.

libname 과 caslib 문장은  오류없이 library가 할당되지만 테이블이 보이지 않습니다.

 

caslib       odbclib       datasource=(scrtype="odbc"              username="xxx"              password="xxxxxxxx" odbc_dsn="XXXXX");

proc casutil;

list files incaslib="odbclib";

run;

 

ERROR: The connection to the data source driver failed.

ERROR: No diagnostic records were returned.

ERROR: Function failed.

ERROR: The action stopped due to errors.

 

[답변]

CASLIB 에 아래 옵션을 추가한 후에도 오류가 발생하는지 확인해 보세요.

dm_unicode="utf-16"

[예시]

caslib       odbclib       datasource=(scrtype="odbc"              username="xxx"              password="xxxxxxxx" odbc_dsn="PEDWDB1" schema="xxxxx" dm_unicode="utf-16");

Version history
Last update:
‎10-05-2021 05:28 AM
Updated by:
Contributors

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

Article Labels
Article Tags