topic Re: Create a stored process in SAS and execute it from Excel and do not create any excel sheets as o in SAS Enterprise Guide

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

Abelp9 — Wed, 01 Feb 2023 09:43:29 GMT

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

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

Sajid01 — Wed, 01 Feb 2023 17:13:21 GMT

Try this

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

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

Abelp9 — Wed, 01 Feb 2023 17:46:39 GMT

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

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

Kurt_Bremser — Wed, 01 Feb 2023 17:58:49 GMT

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.

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

Sajid01 — Wed, 01 Feb 2023 20:30:38 GMT

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.