SASEMOOD Interface Engine

This example shows how to retrieve unemployment rate data for United States (total), starting in January 1973 and ending in January 2019. The output is shown in Output 24.6.1. The MNEMONIC= option specifies the Moody’s data set to retrieve the data from; its mnemonic code is LBR.IUSA. The SAS system option VALIDVARNAME=ANY allows for the special character '.' in the mnemonic code; the same mnemonic code is used to name the SAS variable’s series name in the SAS output data set. The START= and END= options define the date range. Although the native frequency of this series is monthly, the request is for an annual frequency, using the cubic conversion in the CONV= option.

options validvarname=any;

title 'Request Unemployment Data, Annual Frequency Using Cubic Conversion';
LIBNAME moody sasemood "%sysget(MOOD_DATA)"
   mnemonic="LBR.IUSA"
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   freq=annual     /* Convert from monthly to annual frequency */
   conv=cubic
   outjson=labor
   start='1973-01-01'
   end='2019-01-01'
   format=json
   ;

data myLabor;
    set moody.labor;
run;

proc print data=work.myLabor; run;