Date:         Wed, 2 Jan 2002 00:00:23 -0800
Reply-To:     Thomas <mailtee@ALTAVISTA.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Thomas <mailtee@ALTAVISTA.COM>
Organization: http://groups.google.com/
Subject:      Re: FTP and read XPORT data set
Content-Type: text/plain; charset=ISO-8859-1

Kastner.William@BROADBAND.ATT.COM (Kastner, William) wrote in message news:<0D23CDC34632D411BE0400508BCF7F91037B0389@entcoexch10.mediaone.com>...
> I have a series of files in XPORT format sitting on a UNIX server. I am
> trying to download and read them using PC SAS. I have tried using the
> following code but seem to be missing something because I can't get the file
> transferred and read in. The process works fine if I manually download the
> file and read it in using PROC COPY.
>
> FILENAME mycomp FTP "file1.xpt"
>                       CD="/usr/sas/work/servicable"
>                       USER="user"
>                       PASS="****"
>                       HOST="mycomputer.domain.com";
>
> DATA _null_;
>      INFILE comp;
>      INPUT;
>      file 'c:\test.xpt';
>      put _infile_;
> RUN;
>
> libname in xport 'c:\test.xpt';
>
> proc copy out=work in=in;
> run;
>
>
> Can someone please point me in the right direction?
>
> Thanks,
> Bill Kastner

Hi Bill,
There is a mistake here:
DATA _null_;
      INFILE ---* comp *----; (You called the file 'mycomp' but you used 'comp')
      INPUT;
      file 'c:\test.xpt';
      put _infile_;
RUN;