|Date: ||Sat, 4 Apr 1998 17:43:26 +0100|
|Reply-To: ||Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>|
|Organization: ||Crawford Software Consultancy Limited|
|Subject: ||Re: SAS and ODBC -Reply|
In article <firstname.lastname@example.org>, Nirmala Sandhu <sandhu.n@GHC.ORG>
>actually, i was exporting from MS Access
>into SAS-sorry for the confusion. when i do
>so, a work library dataset is created but
>have to manually save it to a permanent
>one. still hoping for suggestions.
If you want a one-level dataset name to be "permanent", then there are
two ways I think I can advise you.
The first works fine. Look up how to assign the USER option. When this
option has a value (a libname already assigned) then any one-level-name
dataset is output to that user=LIBNAME.
1 option user=b3;
2 data test2; run;
NOTE: The data set B3.TEST2 has 1 observations and 0 variables.
NOTE: The DATA statement used 0.17 seconds.
The second is more "iffy". Use the NOworkTerm option. Close SAS and
examine the directory used by your work library. Your dataset should
still be present.
It works on win95, but I'd not expect much success this way on MVS. Unix
would probably be OK....
It all depends on the persistence of the area holding your work library.
Before closing the SAS session, get the definition of the directory (or
physical dataset name) with code like
14 %let workpath=%sysfunc( getoption( work ));
15 %put (&workpath);
But, that is not quite sufficient, so a guaranteed (?) way might be
17 %global workpath;
18 data _null_;
19 set sashelp.vslib( where=( libname = 'WORK' ));
20 call symput( 'workpath', trim( path ));
NOTE: The DATA statement used 0.33 seconds.
22 %put (&workpath);
>Nirmala Sandhu, M.P.H.
>Center for Health Studies
>Group Health Cooperative