SASEFRED Interface Engine

(View the complete code for this example.)

The following statements demonstrate how to use the URL= option to obtain the SERIES and SERIESS data sets for a specified release and how to create a permanent data set named SERIES2 in the MyLib SAS library:^[16]

options validvarname=any;

title 'Specifying the URL= Option to Create the SERIES Data Set';
libname _all_ clear;
libname fred2 sasefred "%sysget(FRED)"
   URL="https://api.stlouisfed.org/fred/release/series?release_id=51"
   APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   ;

data series2;
   set fred2.XFREDtpu;
run;

proc contents
   data=series2;
run;

%macro pri10nom(datname);
data lastob;
   set &datname nobs=last;
   last5=last-4;
   if last>10 then
      call symput('print5',last5);
   else
      call symput('print5',9);
run;
data getall10;
   set &datname(obs=5) &datname(firstobs=&print5);
run;
proc print data=getall10; run;
%mend pri10nom;

title3 "First 5/Last 5 Obs, SERIES2 Data Set";
%pri10nom(series2);

The returned data are stored in the XFREDTPU data set and are copied to the permanent data set named series2.sas7bdat in the MyLib library. A side effect of the DATA step is the automatic creation of two SAS data sets, named series.sas7bdat and seriess.sas7bdat, in the FRED2 library’s location. Many series are returned for release_id=51; Output 48.9.1 shows only the first and last five observations of the SERIES data set.