When i try to update a table in MSSQL through SAS like this
proc sql; update sandtab.opret_sqltabel_fra_sas set Simon = 1 where Simon = 0; quit; run;
It errors out with
ERROR: Open cursor error: ICommand::Execute failed. : The requested properties cannot be supported.
its only seems to be updating that fails, following statement works fine on the same table
proc sql; insert into sandtab.opret_sqltabel_fra_sas ( col1,col2, col3, col4,Simon) values (99, "Simons kontoform", "N", '2019-05-13 09:48:05.033'dt,11); quit; run;
The datatype for column Simon in my SQL table is float.
What happens if you run
proc sql;
connect using SANDTAB;
execute by SANDTAB (
update opret_sqltabel_fra_sas
set Simon = 1
where Simon = 0
);
quit;
Thanks for your reply,
I dont work unfortunately.
16 proc sql;
17 connect using sandtab;
ERROR: SERVER= option, required for connection, not found.
18 execute by sandtab (
19 update opret_sqltabel_fra_sas
20 set Simon = 1
21 where Simon = 0
22 );
ERROR: The SANDTAB engine cannot be found.
ERROR: A Connection to the sandtab DBMS is not currently supported, or is not installed at your site.
23 quit;
Actually ít just got to works this moment, haven't
assigned my libname through the server and not directly
like this
libname Sandtab slibref=Sandtab server=saspi;
And then it worked ok.
Thanks for your input.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.