The SASEXCCM Interface Engine (Experimental)

Example 39.9 Retrieving Information for Availability of Group INDNOs

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 of the 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;