The SASEXCCM Interface Engine

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

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

libname crsp sasexccm 
   "\\bb04smb01\thirdparty\lnx\crspdata\DIZ201006\"
   setid=460
   indno=1000040 indno=1000060 indno=1000080 
   itemlist="TOTCNT;TOTVAL;TRET";

data dindts_all ( where=( caldt >= '15jun2010'd) );
   set crsp.dlyind_ts; 
run;
 
proc print data=dindts_all; run;