Halo sir,thank you for response. Yes, i added schema name in the SMC under schema in library properties. Im successfuly query with libname test "test/directory";
proc sql;
connect to odbc as mycon
(datasrc=SAPHANA user=SAS password=Password);
create table test.SAS_PD as
select *
from connection to mycon
(select *
from SAS.SAS_PD
);
disconnect from mycon;
quit; because in there i able to put schema name before the table name. Using libname or register table via SMC/DI it still throw an error,same error. i try to select only 1 column in SAP HANA table to see the log, amazingly the log show that i select all the column. LIBNAME sash1 ODBC DATAsrc=SAPHANA SCHEMA=SAS user=SAS Password=Password;
proc sql;
select * from sash1.SAS_LGD;
quit; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 proc sql;
27 select * from sash1.SAS_LGD;
ERROR: CLI prepare error: Unable to retrieve columns for table [SAS_LGD].
SQL statement: SELECT * FROM SAS_LGD.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
28 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.46 seconds
cpu time proc sql;
select '/test/date' from sash1.SAS_LGD;
quit; 26 proc sql;
27 select '/BA1/CR0KEYDAT' from sash1.SAS_LGD;
ERROR: CLI prepare error: Unable to retrieve columns for table [SAS_LGD].
SQL statement: SELECT * FROM SAS_LGD.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
28 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.42 seconds
cpu time 0.09 seconds
... View more