SASEBEA Interface Engine

In this example, the BEA data set name is InputOutput, as specified in the SETNAME= option. The TABLEID= option specifies that the request is for TableID 258, Use of Commodities by Industry. The YEAR= option specifies that the selected data are for two years, 2011 and 2012. The output is shown in Output 22.10.1, which contains only the kept variables specified in the KEEP= option: DATE and the variables whose names start with 'Tab258_ROW_FIRE'. Because the row code in the kept variable names is 'FIRE', only the variables in the commodity FIRE (finance, insurance, real estate, rental, and leasing) are kept. 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.10.1 shows the output for the requested years, 2011 and 2012.

options validvarname=any;

title 'Request Use of Commodities by Industry, Table ID 258';
LIBNAME beaIO sasebea "physical path to your folder for storing the BEA data"
   setname=InputOutput
   tableID='258'
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                                                  
   outjson=IOINDC
   year='2011,2012'
   format=json;

data myIOIC;
   set beaio.IOINDC;
run;

proc print data=myIOIC(keep=date Tab258_ROW_FIRE:); run;