The SASEXCCM Interface Engine

This example shows how to retrieve the MPRC, MASK, and MBID time series by PERMNO key access in the STK database. For brevity, the WHERE= option in the DATA step selects a range of MCALDT for 25 observations.

title 'Retrieve IBM Monthly PRC, ASK, and BID by PERMNO Access';
libname _all_ clear;

libname crsp sasexccm 
   "\\tappan\crsp1\data201008_little\MIZ201006\"
   setid=20 
   permno=12490 
   itemlist="MPRC;MASK;MBID";

data mstkts_all( where=( mcaldt >= '30jun2008'd) ) ;
   set crsp.mstk_ts;
run;
proc contents data=mstkts_all;
run;
proc print data=mstkts_all;
run;