SASEBEA Interface Engine

In this example, the BEA data set name is ITA, as specified in the SETNAME= option. The INDICATOR="BalGds" option specifies that the request is for balance on goods time series, and AREAORCOUNTRY=ALL specifies this time series for all countries where it is available. The YEAR='2011,2012' option specifies that the selected data are for two years, 2011 and 2012. The output is shown in Output 22.7.1, which contains 112 variables, whose names are listed by the CONTENTS procedure. 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.

options validvarname=any;

title 'Request Balance on Goods Annual ITA Data for Years 2011 and 2012';
LIBNAME beaita sasebea "physical path to your folder for storing the BEA data"
   setname=ITA
   indicator="BalGds"
   areaOrCountry=All
   freq=A
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                                                  
   outjson=ITAB
   year='2011,2012'
   format=json;

data myITAB;
   set beaita.ITAB;
run;

proc contents data=myITAB; run;