ERROR: The connection has timed out..

[ahk1225]

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.

[ballardw]

I would suggest downloading the file to a local drive.

[Doc_Duke]

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.

[ballardw]

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.

[conti]

Hi,

I have the same problem, how do solve this ?

The connection jas time out...