Hello Everyone, I am trying to connect FM server data (here, PSB) into SAS using ODBC engine. FM server drive was successfully installed for ODBC. Toad data point 3.2 also can connect FM server and I can see the data through Toad. My problme is that it seems SAS connected the FM server with ODBC becasue I can see the list of all data table in the library. Proc contents also show the list of all data from the server. However, when I tried to see the each table using proc sql, the error message comes up, saying the data does not exist. I am stumped becase the libray has the list of all tables but cannot open each table. Did anyone have this kind of problem happened before? Please, help me to access the each table. Thank you in advance. eunji ** I am using SAS 9.3TS1M0 with W32_7PRO platform. *My SAS code; libname psb odbc dbprompt=yes defer=yes datasrc=PSB user=XXX password=XXXXXXX access=readonly preserve_tab_names=yes; proc contents data=psb._ALL_ nods; run; proc sql;create table work.participants as select * from psb.CANCERS;quit; *SAS log; 16 libname psb odbc dbprompt=yes defer=yes datasrc=PSB user=XXX password=XXXXXXX access=readonly 16 ! preserve_tab_names=yes; NOTE: Libref PSB was successfully assigned as follows: Engine: ODBC Physical Name: PSB 17 proc contents data=psb._ALL_ nods; run; NOTE: PROCEDURE CONTENTS used (Total process time): 18 proc sql; create table work.participants as select * from psb.CANCERS; ERROR: File PSB.CANCERS.DATA does not exist. 18 ! quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):
... View more