Date:         Wed, 27 May 2009 16:22:09 -0400
Reply-To:     "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject:      Re: Is there anyways to save WORK dataset
In-Reply-To:  <200905271958.n4RHMCqH026997@malibu.cc.uga.edu>
Content-Type: text/plain; charset=us-ascii

> From: Abc Unha
>
> I am running SAS in batch mode. It has hundreds of dataset
> that is writing
> into work directory. At the end it creates one dataset that will be
> written in permanent libaray.
> I need to debug some steps and I was wondering If there is a way to
> permanently store work datasets?

- - - autoexec.sas - - -
filename Project '.';


This is the obvious solution:

- - - MyBigJob-Test.sas - - -
%Include Project(MyBigJob)/source2;

libname LibWork '..\sas7bWork';*testing;

PROC Copy in      =    Work
          out     = LibWork;
         *exclude   ...;
         *select    ...;


in my SiteIncl folder I have:

- - - LibWork.sas - - -
libname LibWork '..\sas7bWork';*testing;

- - - CopyWork.sas - - -
%Include SiteIncl(LibWork);
PROC Copy in      =    Work
          out     = LibWork;

- - - CopyLibWork.sas - - -
%Include SiteIncl(LibWork);
PROC Copy in      = LibWork
          out     =    Work;

then your test program is:

- - - MyBigJob-Test.sas - - -
%Include Project(MyBigJob)/source2;
%Include SiteIncl(CopyWork)/source2;

and also:

- - - MyBigJob-precursor-Test.sas - - -
%Include SiteIncl(CopyLibWork);
%Include Project(MyBigJob-precursor)/source2;

Ron Fehd  the module/routine/subroutine maven  CDC Atlanta GA USA RJF2
at cdc dot gov