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.
I would suggest downloading the file to a local drive.
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.
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.
Hi,
I have the same problem, how do solve this ?
The connection jas time out...
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.