SASEBEA Interface Engine

This example requests auto and truck detail data from the NIPA Underlying Detail data set. The request is for monthly data for the years 2015 and 2016. The SETNAME= option specifies the data set NIUNDERLYINGDETAIL. The TABLENAME= option specifies the table U70205S (Truck and Auto Unit Sales, Production, Inventories, Expenditures, and Price) time series. The FREQ= option selects monthly time series, and the YEAR= option specifies the years 2015 and 2016 as the range of data. The SAS code is shown after the next paragraph. Output 22.1.1 shows the output for the selected date range.

The SET statement reads observations from the input data set Beanip.NIPU, and the DATA step stores them in a SAS data set named myNIPAU. When all the data are retrieved, they are placed in a SAS data set that is named by the OUT= option and is located in the folder specified by the physical-name in the LIBNAME statement.

options validvarname=any;

title 'Request Truck Unit Sales, Production, Inventories, Expenditures, and Price,
       Monthly, for 2015 and 2016';
LIBNAME beanip sasebea "physical path to your folder for storing the BEA data"
   setname=NIUnderlyingDetail
   TableName="U70205S"
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'                                                                                                                                
   freq=M
   outjson=NIPU
   year='2015,2016'
   format=json;

data myNIPAU;
   set beanip.NIPU;
run;

proc print data=myNIPAU; run;