I have a stored process with this code;
PROC SQL;
CREATE TABLE DDC.OUTPUTQ AS
SELECT DOS
FROM WORK.THINGS;
QUIT;
When I execute the stored process from excel through the sas addin, it generates a sheet with the content of the DDC.OUTPUTQ table, how can I do so that it does not generate any table in the excel file without passing the DDC.OUTPUTQ table to a temp table? It is mandatory that the table is created in the DDC library and that when executing the stored process in excel it does not create a sheet with the content of this table
Hello @Abelp9
Here is a test stored process that you can create and run in Excel (AMO installed)
libname mylib "/home/myuid";
proc sql noprint;
create table mylib.mytable as
select * from sashelp.class;
quit;
It will only create the table mytable in /'home/myuid'.The only thing you would see in excel is "Stored_process_name" executed at date:time.
There will be no other output in your excel.
You should be able to execute this stored process with Rest-API too.
@Kurt_Bremser has pointed out there must be something in your code that is sending data to excel.
Try this
PROC SQL noprint;
CREATE TABLE DDC.OUTPUTQ AS
SELECT DOS
FROM WORK.THINGS;
QUIT;
I have tried but "noprint" does is that it doesn't appear as output in SAS but in the file it keeps coming out. Thanks for your answer
This step does not create any output, it just creates a dataset. There must be something else in the STP which sends the data to Excel.
Hello @Abelp9
Here is a test stored process that you can create and run in Excel (AMO installed)
libname mylib "/home/myuid";
proc sql noprint;
create table mylib.mytable as
select * from sashelp.class;
quit;
It will only create the table mytable in /'home/myuid'.The only thing you would see in excel is "Stored_process_name" executed at date:time.
There will be no other output in your excel.
You should be able to execute this stored process with Rest-API too.
@Kurt_Bremser has pointed out there must be something in your code that is sending data to excel.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.