Date:         Tue, 20 Jun 2006 12:37:50 -0400
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: To read SAS Dataset stored in an FTP server

On Tue, 20 Jun 2006 08:48:29 -0700, Choate, Paul@DDS <pchoate@DDS.CA.GOV> wrote:

>Arnab -
>
>Removing the unneeded "Data;" statement, and use something other than
>"Fileref" for your fileref.
>
>This works for me:
>
>
>FILENAME  SPSSFile  FTP
> '/ddsinfo/POR/ca2r4efc.por'
> HOST='158.96.234.10'
> USER='myid'
> PASS='mypass'
> DEBUG;
>
>LIBNAME  SPSSFile  SPSS;
>
>PROC Contents data=SPSSFile._first_;
>run;
>
>
>hth
>
>
>Paul Choate
>DDS Data Extraction
>(916) 654-2160
>
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>abose
>> Sent: Tuesday, June 20, 2006 5:27 AM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: To read SAS Dataset stored in an FTP server
>>
>> Hi,
>> I've searched and found ways to access RAW (text files), even datasets
>> in foreign format... (see the code below) but I never found a way to
>> read SAS file across ftp.
>>
>> Does anyone know how to read a SAS Dataset over the FTP? I have tried
>> modifying the following code and putting engines V8 or V9 instead of
>> SPSS, but that does not work.

FTP is sequential, so direct-access engines like V8 and V9 are not going to
work over FTP.

>>
>> DATA ;
>> FILENAME  fileref FTP      /* Must us the FTP device
>> type  */
>>  '/pub/irss/roper/gss7296/spss.portable'  /* Complete path and file
>> name, NEVER */
>>             /* use the .gz file extension
>>   */
>>  HOST='ftp.irss.unc.edu'      /* Address of IRSS FTP site
>>   */
>>  USER='anonymous'       /* Login as anonymous
>>   */
>>  PASS='userid@email.address'     /* PW is E-mail address
>>   */
>>  DEBUG ;          /* Useful/optional diagnostic
>> info */
>> LIBNAME  fileref  SPSS ;      /* SPSS engine
>>   */
>> PROC FREQ DATA=fileref._first_ ;
>>   TABLES  race ;
>> run;
>>
>> Regards,
>> Arnab.