Date:         Mon, 2 Nov 2009 17:28:26 +0100
Reply-To:     Fernández Rodríguez, Dani
              <DFernandez@CST.CAT>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Fernández Rodríguez, Dani
              <DFernandez@CST.CAT>
Subject:      Re: SUSPECT: RE: Download a  file from HTTP
Comments: To: Philip Rack <PhilRack@MineQuest.com>
In-Reply-To:  <004401ca5bd8$96042cc0$c20c8640$@com>
Content-Type: text/plain; charset="iso-8859-1"

Hi Phillip,

It gives me the same answer:


91   filename  _ORCL URL
92   'http://ichart.finance.yahoo.com/table.csv?s=ORCL&d=10&e=2&f=2009&g=d&a=2&b=
93   2&c=1988&ignore=.csv' DEBUG;
94   options validvarname=v7;
95   DATA ORCL;
96   INFILE _ORCL;
97   INPUT data  open high low close adj_close;
98   run;

ERROR: 10060 - WSAETIMEDOUT.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ORCL may be incomplete.  When this step was stopped there were 0
         observations and 6 variables.
WARNING: Data set WORK.ORCL was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           21.32 seconds
      cpu time            0.00 seconds










-----Mensaje original-----
De: Philip Rack [mailto:PhilRack@MineQuest.com]
Enviado el: dilluns, 2 / novembre / 2009 17:22
Para: Fernández Rodríguez, Dani; SAS-L@LISTSERV.UGA.EDU
Asunto: SUSPECT: RE: Download a file from HTTP

To get a little more information, try putting the option DEBUG at the end of
your filename statement. So that it looks like:

filename  _ORCL URL
'http://ichart.finance.yahoo.com/table.csv?s=ORCL&d=10&e=2&f=2009&g=d&a=2&b=
2&c=1988&ignore=.csv' DEBUG;


Philip Rack
MineQuest, LLC
SAS & WPS Consulting and WPS Reseller
Tel: (614) 457-3714
Web: www.MineQuest.com
Blog: www.MineQuest.com/WordPress


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Fernández Rodríguez, Dani
Sent: Monday, November 02, 2009 11:06 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Download a file from HTTP

Hi,

Infile and filename is not my best skill...

I would like to download a csv file from HTTP directly to SAS

(without having first to execute an Excel macro and a PROC Import from SAS
later)

, the address is:

http://ichart.finance.yahoo.com/table.csv?s=ORCL&d=10&e=2&f=2009&g=d&a=2&b=2
&c=1988&ignore=.csv



I executed this code:



filename  _ORCL URL

'http://ichart.finance.yahoo.com/table.csv?s=ORCL&d=10&e=2&f=2009&g=d&a=2&b=
2&c=1988&ignore=.csv';

options validvarname=v7;

DATA ORCL;

INFILE _ORCL;

INPUT data  open high low close adj_close;

run;



but the LOG tells me:



ERROR: 10060 - WSAETIMEDOUT.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.ORCL may be incomplete.  When this step was
stopped there were 0

         observations and 6 variables.

NOTE: DATA statement used (Total process time):

      real time           21.11 seconds

      cpu time            0.00 seconds



what can I do?



Thankx you very much in advance.



Daniel Fernandez.

Barcelona.