SASEMOOD Interface Engine

This example shows how to retrieve Standard & Poor’s Dow Jones Indices data, starting in January 2018 and ending in February 2018. The output is shown in Output 24.4.1. The MNEMONIC= option specifies the Moody’s data set to retrieve the data from; its mnemonic code is SP500D.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.

options validvarname=any;

title 'Request S&P 500 Data, Daily Data';
LIBNAME moody sasemood "%sysget(MOOD_DATA)"
   mnemonic="SP500D.IUSA"
   user='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   pass='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
   freq=daily
   conv=cubic
   outjson=sp500
   start='2018-01-01'
   end='2018-02-01'
   format=json
   ;

data mySP500;
    set moody.sp500;
run;

proc print data=work.mySP500; run;