Example 38.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 38.3.1.

Output 38.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