topic Re: ERROR: The connection has timed out.. in SAS Programming

ERROR: The connection has timed out..

ahk1225 — Fri, 05 Aug 2016 14:48:02 GMT

I excuted the following program and have error message "

ERROR: The connection has timed out.."

filename DAAA url

'http://research.stlouisfed.org/fred2/series/DAAA/downloaddata/DAAA.csv'

;

data BY_AAA(drop=dd);

length dd $10;

format date date9.;

infile DAAA dlm="," dsd;

input dd$ value;

date=input(dd,yymmdd10.);

if not missing(date) then output;

run;

filename DAAA clear;

How to resolve this issue? I tried different method, but could not resolve it.

Re: ERROR: The connection has timed out..

ballardw — Fri, 05 Aug 2016 14:56:02 GMT

I would suggest downloading the file to a local drive.

Re: ERROR: The connection has timed out..

Doc_Duke — Fri, 05 Aug 2016 18:26:12 GMT

take a look at

http://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/

for methods to get to the data you want in a dynamic fashion.

Re: ERROR: The connection has timed out..

ballardw — Fri, 05 Aug 2016 19:36:49 GMT

Interesting, times out when I run the code as well but only took about 4 seconds to download to local drive.

BTW, I would suggest reading the data with this:

data work.BY_AAA;
   Informat date yymmdd10. ;
   format date date9.;
   infile DAAA dlm="," dsd;
   input date value;
   if not missing(date) then output;
run;

If you know the format when reading it, might as well do it directly and skip the step of converting from and dropping a string variable.

Re: ERROR: The connection has timed out..

conti — Fri, 06 Apr 2018 12:45:48 GMT

Hi,

I have the same problem, how do solve this ?

The connection jas time out...