/*----------------------------------------------------------------

                   SAS SAMPLE LIBRARY

       Name: fredex12.sas
Description: Example program from SAS/ETS User's Guide,
             The SASEFRED Interface Engine
      Title: Specifying the URL= Option to Create SERIES_CAT5 Data Set.

    Product: SAS/ETS Software
       Keys: FRED data extraction
      Procs: SASEFRED
      Notes: Read this before you run this sample.
             The sample data provided resides in the ets/sasmisc folder.
             Define a system environment variable,
             FRED, to the path of your  writeable folder containing
             the XFREDtpu.xml as your destination folder for FRED data.
             To assign a fileref to the external file to be processed,
             use the following form of the libname statement:

        libname fred sasefred "%sysget(FRED)"
           URL="https://api.stlouisfed.org/fred/category/series?category_id=125"
           APIKEY='< your FRED apikey >'
           ;
 ----------------------------------------------------------------*/


options validvarname=any;

title 'Specifying the URL= Option to Create the SERIES_CAT5 Data Set';
libname _all_ clear;
libname mylib "< path to your folder for data >";
libname fred5 sasefred "%sysget(FRED)"
   debug=on
   URL="https://api.stlouisfed.org/fred/category/series?category_id=125"
   APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   ;

data mylib.series_cat5;
   set fred5.XFREDtpu;
run;

proc print
   data=mylib.series_cat5;
run;

proc contents
   data=mylib.series_cat5;
run;