topic Re: SAS Stored process vs Block execution in New SAS User

SAS Stored process vs Block execution

lyudmilpetrov — Thu, 13 Jun 2019 14:18:07 GMT

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

Re: SAS Stored process vs Block execution

Kurt_Bremser — Thu, 13 Jun 2019 17:23:28 GMT

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.

Re: SAS Stored process vs Block execution

lyudmilpetrov — Thu, 13 Jun 2019 18:09:56 GMT

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