SASEBEA Interface Engine

In this example, the BEA data set name is IIP, as specified in the SETNAME= option. The TYPEOFINVESTMENT= option specifies that the request is for two types of investments: US liabilities excluding financial derivatives and US liabilities to foreign official agencies. The COMPONENT= option requests the position statistics (POS) for the two specified investment types. The YEAR= option specifies that the selected data are for 2013, and the FREQ= option specifies the time period to be quarterly, not seasonally adjusted. The output is shown in Output 22.9.1, which contains three variables: DATE, FinLiabsExclFinDerivPos_QNSA, and TSI_IipFinLiabsFoaPos_QNSA. The CONTENTS procedure shows the attributes for each variable, including the description (shown as the label). 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.9.1 shows the output for the requested year, 2013.

options validvarname=any;

title 'Request Two Quarterly Investment Positions for 2013';
LIBNAME beaiip sasebea "physical path to your folder for storing the BEA data"
   setname=IIP
   typeOfInvestment="FinLiabsFoa,FinLiabsExclFinDeriv"
   component=Pos
   freq=QNSA
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                                                  
   outjson=IIPQ
   year='2013'
   format=json;

data myIIPQ;
   set beaiip.IIPQ;
run;

proc contents data=myIIPQ; run;
proc print data=myIIPQ; run;