SASEBEA Interface Engine

In this example, the BEA data set name is FixedAssets, as specified in the SETNAME= option. The TABLENAME="FAAt201" specifies that the statistics for one table, named FAAt201, is requested. The table contains current-cost net stock of private fixed assets, equipment, structures, and intellectual property products by type. The YEAR='2015,2016,2017,2018,2019' option specifies that the range of data is for five years, 2015 through 2019. The output is shown in Output 22.4.1, which contains 106 variables whose names are given by the series code (with the exception of the DATE variable). 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.4.1 shows the output for the last five years, ranging from 2015 to 2019.

options validvarname=any;

title 'Request Table FAAt201 Statistics from Fixed Assets, Annual Data';
LIBNAME beaFAAt sasebea "physical path to your folder for storing the BEA data"
   setname=FixedAssets
   TableName="FAAt201"
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                                                  
   outjson=MCOST
   year='2015,2016,2017,2018,2019'
   format=json;

data myMCOST;
   set beaFAAt.MCOST;
run;

proc print data=myMCOST; run;