topic Re: How can I save and store result in the middle so that it is not run again in the process in SAS Enterprise Guide

How can I save and store result in the middle so that it is not run again in the process

Yiting — Wed, 28 Aug 2019 11:44:21 GMT

Hi, I have a big SAS EG project so that there are many queries. In SPSS modeler, it is possible to save some results (NOT export to Excel or anything), just pin the result so that when you run the process again, the part leading to it is not run again and it saves some time... It is called stored procedure. I wonder if SAS EG has such a function? Thanks in advance!

Re: How can I save and store result in the middle so that it is not run again in the process

Reeza — Wed, 28 Aug 2019 14:08:59 GMT

That’s the difference between a permanent library and the work library.

If you write your files to a permanent library you can save them between sessions/runs.

In an Enterprise set up you usually have a permanent user library set up by default under your name somewhere.

@Yiting wrote:

Hi, I have a big SAS EG project so that there are many queries. In SPSS modeler, it is possible to save some results (NOT export to Excel or anything), just pin the result so that when you run the process again, the part leading to it is not run again and it saves some time... It is called stored procedure. I wonder if SAS EG has such a function? Thanks in advance!

Re: How can I save and store result in the middle so that it is not run again in the process

Astounding — Thu, 29 Aug 2019 00:30:12 GMT

Are you able to split the project into 2 projects?

Saving the results should be fairly easy. Add to both projects:

libname mylib "path to folder for saving results" ;

options user=mylib;