The SASECRSP engine defaults to providing access to the entire range of available data when you do not restrict the range (that is, when you do not use 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 Time Series Data without RANGE= Option
| 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 |