ERROR: The connection has timed out..

Reply
Occasional Contributor
Posts: 5

ERROR: The connection has timed out..

 

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.

 

Grand Advisor
Posts: 10,211

Re: ERROR: The connection has timed out..

I would suggest downloading the file to a local drive.

Valued Guide
Posts: 2,111

Re: ERROR: The connection has timed out..

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.

Grand Advisor
Posts: 10,211

Re: ERROR: The connection has timed out..

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.

 

Ask a Question
Discussion stats
  • 3 replies
  • 671 views
  • 0 likes
  • 3 in conversation