SASEBEA Interface Engine

In this example, the BEA data set name is UnderlyingGDPbyIndustry, as specified in the SETNAME= option. The TABLEID=ALL specifies that the statistics for all table IDs are requested for the gross domestic product industry (INDUSTRY='GDP'). The YEAR=ALL option specifies that the range of data is for all available years. The output is shown in Output 22.3.1, which contains nine variables, whose names are prefixed with the industry code (GDP) followed by '_'. With the exception of the DATE variable, the variable names also have a suffix of '_', followed by the table ID. Between the prefix and suffix is the main part of the name, which is the truncated description of the time series. Together, the three parts, prefix, description and suffix, name each of the time series variables in the SAS output data set. The FREQ= option selects annual data, and the OUTJSON= option specifies the name of the SAS output data set, which is also the name of the JSON data file that is retrieved from the BEA website and read into SAS. Output 22.3.1 shows the output for all available years.

options validvarname=any;

title 'Request GDP Statistics from Underlying Gross Domestic Product by Industry';
LIBNAME beagu sasebea "physical path to your folder for storing the BEA data"
   setname=underlyingGDPbyIndustry
   TableID=ALL
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                              
   freq=A
   industry='GDP'
   outjson=gdp3u
   year=ALL
   format=json;

data myGDP3U;
   set beagu.gdp3u;
run;

proc print data=myGDP3U; run;