BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Abelp9
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
Sajid01
Meteorite | Level 14

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.

 

 

View solution in original post

4 REPLIES 4
Sajid01
Meteorite | Level 14

Try this

PROC SQL noprint;
CREATE TABLE DDC.OUTPUTQ AS
SELECT DOS
FROM WORK.THINGS;
QUIT;
Abelp9
Quartz | Level 8

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

Sajid01
Meteorite | Level 14

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.

 

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1717 views
  • 5 likes
  • 3 in conversation