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