SAS Stored process vs Block execution

[lyudmilpetrov]

Hi All,

I have a simple stored process, as below:

*ProcessBody;
%STPBEGIN;
PROC SQL;
CREATE TABLE TEST AS
SELECT * from SASHELP.CARS (OBS=2);
select * from TEST;
QUIT;
%STPEND;

when executed it says that table is created and table is presented from the select.

But it is not visible in the folder WORK.

The same code without %STPBEGIN; and %STPEND;, which is only code block, when executed, executes the same way but this time produces the table.

Why is that behavior ,

Lyudmil Petrov

[Kurt_Bremser · Accepted solution]

WORK is individual for each SAS session, and in the case of stored processes, cleared after each STP execution, so you cannot expect to see it in any other WORK library. Create the dataset in a permanent library instead.

[lyudmilpetrov]

Thank you so much Kurt for your fast response, your answer perfectly explains why.

I am new to SAS and I am trying to execute the stored process within .NET, my Stored process is as follows

*ProcessBody;
%STPBEGIN;
PROC SQL;
CREATE TABLE BP AS
SELECT * from SASHELP.BASEBALL (OBS=2);
QUIT;
%STPEND;

How I can change it to make the table saved into permanent library.

Thank you so much in advance and all the best,

Lyudmil