SUSPECT: RE: Download a file from HTTP
in [SAS]
|
From: Fernández Rodríguez, on 2 Nov 2009 11:28 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(a)MineQuest.com] Enviado el: dilluns, 2 / novembre / 2009 17:22 Para: Fern�ndez Rodr�guez, Dani; SAS-L(a)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(a)LISTSERV.UGA.EDU] On Behalf Of Fern�ndez Rodr�guez, Dani Sent: Monday, November 02, 2009 11:06 AM To: SAS-L(a)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.
From: Philip Rack on 2 Nov 2009 11:34 Can you ping the IP address? Open a CMD window and type: ping 68.142.196.15 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(a)LISTSERV.UGA.EDU] On Behalf Of Fern�ndez Rodr�guez, Dani Sent: Monday, November 02, 2009 11:28 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: SUSPECT: RE: Download a file from HTTP 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(a)MineQuest.com] Enviado el: dilluns, 2 / novembre / 2009 17:22 Para: Fern�ndez Rodr�guez, Dani; SAS-L(a)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(a)LISTSERV.UGA.EDU] On Behalf Of Fern�ndez Rodr�guez, Dani Sent: Monday, November 02, 2009 11:06 AM To: SAS-L(a)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.
|
Pages: 1 Prev: Schemper's V macro sas 9.2 Next: SAS Question on applying formula contained in a variable |