Date:         Mon, 30 Oct 2006 15:58:49 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: trying to read .xpt ???

On Sun, 29 Oct 2006 11:30:40 -0600, SAS_learner <proccontents@GMAIL.COM> wrote:

> Even though the file is in the location I pointed to still it is
>complaining that there is no file at location, can somebody point where I
>going wrong. And one more thing in the Log as below it say's
>"Input library LABPATH is sequential." What does this means ???????????
>
>
>* Directory path of imported SAS transport file;
>libname labpath xport "C:\Documents and
>Settings\tathap\Desktop\SAS\lexabpi.xpt";

Is the newline bwtween "and" and "Settings" in your code, or is it an
artifact of e-mail processing? If it's in the code, it apparently is *not*
replaced by a blank, and that seems to be the problem.

I generally avoid such wrapping inside a quoted string. I would make it:

   libname labpath xport
   "C:\Documents and Settings\tathap\Desktop\SAS\lexabpi.xpt"
   ;

See if that fixes things.

>libname labdset 'C:\Documents and Settings\XXXXX\Desktop\SAS';
>* Extract labs dataset from transport file;
>proc copy in=labpath memtype=data out=work;
>run;
>
>libname newlib 'C:\Documents and Settings\XXXX\Desktop\SAS';
>filename tranfile 'C:\Documents and
>Settings\tathap\Desktop\SAS\lexabpi.xpt';
>proc cimport library=newlib infile=tranfile;
>run;
>
>NOTE: Input library LABPATH is sequential. ( What is this Error means )
>ERROR: Physical file does not exist, C:\Documents and
>Settings\tathap\Desktop\SAS\lexabpi.xpt.
>NOTE: Statements not processed because of errors noted above.
>NOTE: PROCEDURE COPY used:
>      real time           0.01 seconds
>      cpu time            0.01 seconds
>
>NOTE: The SAS System stopped processing this step because of errors.
>49
>50   libname newlib 'C:\Documents and Settings\tathap\Desktop\SAS';
>NOTE: Libname NEWLIB refers to the same physical library as LABDSET.
>NOTE: Libref NEWLIB was successfully assigned as follows:
>      Engine:        V8
>      Physical Name: C:\Documents and Settings\tathap\Desktop\SAS
>51   filename tranfile 'C:\Documents and
>Settings\tathap\Desktop\SAS\lexabpi.xpt';
>
>52   proc cimport library=newlib infile=tranfile;
>53   run;
>
>ERROR: Physical file does not exist, C:\Documents and
>Settings\tathap\Desktop\SAS\lexabpi.xpt.
>NOTE: The SAS System stopped processing this step because of errors.
>NOTE: PROCEDURE CIMPORT used:
>      real time           0.00 seconds
>      cpu time            0.00 seconds