Resources

Specifying Ranges for Individual Keys with the INSET= Option

/*----------------------------------------------------------------

                    SAS Sample Library

        Name: crpex05.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASECRSP Interface Engine
    Title: Specifying Ranges for Individual Keys with the INSET= Option
  Product: SAS/ETS Software
     Keys: Stock data access, CRSPAccess, INSET= Option, PERMNO, Date Range
    Procs: SASECRSP
    Notes: Read this before you run this sample.
           The CRSP Stock database resides in the  CRSP_MSTK folder. You
           must install your CRSP Monthly Stock data
           and define your system environment
           variable, CRSP_MSTK, to point to the physical path
           of your installed CRSP Stock database. Use the following
           form of the libname statement:

libname mstk2 sasecrsp "%sysget(CRSP_MSTK)"
        setid=20
        inset='testin2,PERMNO,PERMNO,DATE1,DATE2';
----------------------------------------------------------------*/

title2 'INSET=testin2 uses date ranges along with PERMNOs:';
title3 '10107, 12490, 14322, 25788';
title4 'Begin dates and end dates for each permno are used in the INSET';

data testin2;
   permno = 10107; date1 = 19980731; date2 = 19981231; output;
   permno = 12490; date1 = 19970101; date2 = 19971231; output;
   permno = 14322; date1 = 19950731; date2 = 19960131; output;
   permno = 25778; date1 = 19950101; date2 = 19950331; output;
run;

libname _all_ clear;
libname mstk2 sasecrsp "/r/tappan/vol/vol1/crsp1/data201212/MIZ201212/"
        setid=20
        inset='testin2,PERMNO,PERMNO,DATE1,DATE2';

data b;
   set mstk2.prc;
run;

proc print data=b;
run;