Create a stored process in SAS and execute it from Excel and do not create any excel sheets as outpu

[Abelp9]

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

[Sajid01]

Try this

PROC SQL noprint;
CREATE TABLE DDC.OUTPUTQ AS
SELECT DOS
FROM WORK.THINGS;
QUIT;

[Abelp9]

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

[Kurt_Bremser]

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.

[Sajid01 · Accepted solution]

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.