Date:         Wed, 7 Dec 2005 05:16:37 -0800
Reply-To:     RolandRB <rolandberry@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RolandRB <rolandberry@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Changing default library for present SAS/code session
Comments: To: sas-l@uga.edu
In-Reply-To:  <1133960735.730610.77040@g47g2000cwa.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Hari wrote:
> Roland,
>
> Thanks for a really prompt response.  Im sorry, I misread your original
> post "Type options".
>
> I tried out --> options user=ABCproj;
>
> and after this line I ran the proc export I have listed in my previous
> post.
>
> Strangely as soon as I run options I get one more library by the name
> "User" and when I run Proc export I get the new file "RAWTOTAL" both in
> the library ABCproj and also in the library "User". I see that this
> Library "User" has the same path as ABCproj. Iam not able to figure out
> as to why it created a new library by the name "user". Is this normal?
>
> Please guide me.
>
> Regards,
> Hari
> India


See what I have done below. I set user=sasuser and write to a dataset
named testxxx and when I print dataset sasuser.testxxx it is in there
because instead of the work library being used for one-level dataset
names, sasuser is used instead. Indeed, if I do a "proc options" after
running the code below I see this line:

USER=sasuser      Default location for all one-level SAS data set names


9    options user=sasuser;
10
11   data testxxx;
12     dummy="dummy";
13   run;

NOTE: The data set SASUSER.TESTXXX has 1 observations and 1 variables.
NOTE: DATA statement used:
      real time           0.01 seconds
      cpu time            0.01 seconds


14
15   proc print data=sasuser.testxxx;
16   run;

NOTE: There were 1 observations read from the data set SASUSER.TESTXXX.
NOTE: PROCEDURE PRINT used:
      real time           0.00 seconds
      cpu time            0.01 seconds