The SASECRSP Interface Engine: Accessing One PERMNO Using No RANGE

The SASECRSP Interface Engine

Example 33.3 Accessing One PERMNO Using No RANGE

SASECRSP defaults to providing access to the entire range of available data when no range restriction is specified via the RANGE= option.

This example shows access of the entire range of available data for one particular PERMNO extracted from the monthly data set.

   title2 'Select only PERMNO = 81871';
   title3 'Valid trading dates (19890131--19981231)';
   title4 'No range option, leave wide open';
   
   libname _all_ clear;
   libname testit3 sasecrsp "%sysget(CRSP_MSTK)"
           setid=20
           permno=81871;
   
   data c;
      set testit3.ask;
   run;
   
   proc print data=c;
   run;

The result is shown in Output 33.3.1.

Output 33.3.1 PERMNO=81871 of ASK Monthly without RANGE

Select only PERMNO = 81871

Valid trading dates (19890131--19981231)

No range option, leave wide open

Obs	PERMNO	CALDT	ASK
1	81871	19950731	18.25000
2	81871	19950831	19.25000
3	81871	19950929	26.00000
4	81871	19951031	26.00000
5	81871	19951130	25.50000
6	81871	19951229	24.25000
7	81871	19960131	22.00000
8	81871	19960229	32.50000
9	81871	19960329	30.25000
10	81871	19960430	33.75000
11	81871	19960531	27.50000
12	81871	19960628	30.50000
13	81871	19960731	26.12500
14	81871	19960830	19.12500
15	81871	19960930	19.50000
16	81871	19961031	14.00000
17	81871	19961129	18.75000
18	81871	19961231	24.25000
19	81871	19970131	29.75000
20	81871	19970228	24.37500
21	81871	19970331	15.00000
22	81871	19970430	18.25000
23	81871	19970530	25.12500
24	81871	19970630	31.12500
25	81871	19970731	35.00000
26	81871	19970829	33.00000
27	81871	19970930	26.81250
28	81871	19971031	18.37500
29	81871	19971128	16.50000
30	81871	19971231	16.25000
31	81871	19980130	22.75000
32	81871	19980227	21.00000
33	81871	19980331	22.50000
34	81871	19980430	16.12500
35	81871	19980529	11.12500
36	81871	19980630	13.43750
37	81871	19980731	22.87500
38	81871	19980831	17.75000
39	81871	19980930	24.25000
40	81871	19981030	26.00000

Top of Page