The SASEXCCM Interface Engine

This example shows how to retrieve header information about group data and how to obtain a list of all the available INDNO keys in the IND database. The INDNO= option is intentionally omitted so that a default list is generated of all INDNOs in the database that are available for SETID 440.

title 'Retrieve Header Information for a Complete INDNO list';
libname _all_ clear;

libname crsp sasexccm
   "\\bb04smb01\thirdparty\lnx\crspdata\DIZ201006\"
   setid=440
   itemlist="INDNOG.*;INDCOG.*;INDNAMEG.*;GROUPNAMEG.*";

data dgindts_all;
   set crsp.indhdrg;
run;

proc print data=dgindts_all(keep=kyindno indnameg); run;