The SASEXCCM Interface Engine

This example shows how to retrieve monthly time series by using INDNO key access in the IND database. For brevity, the WHERE= option in the DATA step selects a recent range of MCALDT.

title 'Retrieve Several Monthly Time Series by INDNO Access';
libname _all_ clear;

libname crsp sasexccm
   "\\tappan\crsp1\data201008_little\MIZ201006\"
   setid=420
   indno=1000040 indno=1000060 indno=1000080
   itemlist="MAIND;MARET;MIIND";

data mindts_all ( where=( mcaldt >= '30jun2009'd) );
   set crsp.mthind_ts;
run;

proc print data=mindts_all; run;