The SASEFRED Interface Engine

The following statements demonstrate how to use the URL= option to obtain the first 10 sources (LIMIT=10) for the SOURCES6 data set for today’s date and how to create a permanent data set named SOURCES6 in the MyLib SAS library:

title 'Specifying the URL= Option to Create the SOURCES6 Data Set';
libname _all_ clear;
libname mylib "U:\fred940\doc\";

libname fred6 sasefred "U:\fred940\test\"
   debug=on
   URL="http://api.stlouisfed.org/fred/sources?limit=10"
   APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   ;

data mylib.sources6;
   set fred6.XFREDtpu;
run;

proc print
   data=mylib.sources6;
run;

proc contents
   data=mylib.sources6;
run;

The returned data are stored in the XFREDTPU data set and are copied to the permanent data set named sources6.sas7bdat in the MyLib library. A side effect of the DATA step is the automatic creation of two SAS data sets named source.sas7bdat and sources.sas7bdat in the FRED6 library’s location. Sixty-eight sources could be returned for today’s date, but the LIMIT=10 option obtains only the first 10 sources, as shown in Output 48.13.1.