SASEBEA Interface Engine

In this example, the BEA data set name is IntlServTrade, as specified in the SETNAME= option. The TYPEOFSERVICE= option specifies that the request is for advertising services. The TRADEDIRECTION= option specifies that both imports and exports data are selected. The AFFILIATION= option specifies that all affiliations are selected. The YEAR= option specifies that the selected data are for all years. Because these data are available starting in 1999 and ending in 2019, only the data for those years are retrieved. The output is shown in Output 22.11.1. Because DESCRIPTION=SHORT is the default, when the PROC PRINT statement uses the LABEL option, each column heading in the output lists the BEA time series indicator using the prefix 'TSI_Ist' for each indicator. If the PROC PRINT statement did not use the LABEL option, then the column headings in the output would have been ISTVAR1, ISTVAR2, ISTVAR3, and ISTVAR4, which are the actual variable names used by the engine. To see a list of all of the variables and their corresponding labels, use the PROC CONTENTS statement.

options validvarname=any;

title 'Advertising Services, All Affiliations and All Years';
LIBNAME beaISL sasebea "physical path to your folder for storing the BEA data"
   setname=IntlServTrade
   typeOfService='Advertising'
   TradeDirection=All
   affiliation=All
   areaOrCountry='Canada,Germany'
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                                                  
   outjson=ISLADS
   year=All
   format=json;

data myISLADS;
   set beaISL.ISLADS;
run;

proc print label data=myISLADS; run;