The SASECRSP Interface Engine |
Example 35.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 35.3.1.
Output 35.3.1
PERMNO=81871 of ASK Monthly without RANGE
|
81871 |
19950731 |
18.25000 |
81871 |
19950831 |
19.25000 |
81871 |
19950929 |
26.00000 |
81871 |
19951031 |
26.00000 |
81871 |
19951130 |
25.50000 |
81871 |
19951229 |
24.25000 |
81871 |
19960131 |
22.00000 |
81871 |
19960229 |
32.50000 |
81871 |
19960329 |
30.25000 |
81871 |
19960430 |
33.75000 |
81871 |
19960531 |
27.50000 |
81871 |
19960628 |
30.50000 |
81871 |
19960731 |
26.12500 |
81871 |
19960830 |
19.12500 |
81871 |
19960930 |
19.50000 |
81871 |
19961031 |
14.00000 |
81871 |
19961129 |
18.75000 |
81871 |
19961231 |
24.25000 |
81871 |
19970131 |
29.75000 |
81871 |
19970228 |
24.37500 |
81871 |
19970331 |
15.00000 |
81871 |
19970430 |
18.25000 |
81871 |
19970530 |
25.12500 |
81871 |
19970630 |
31.12500 |
81871 |
19970731 |
35.00000 |
81871 |
19970829 |
33.00000 |
81871 |
19970930 |
26.81250 |
81871 |
19971031 |
18.37500 |
81871 |
19971128 |
16.50000 |
81871 |
19971231 |
16.25000 |
81871 |
19980130 |
22.75000 |
81871 |
19980227 |
21.00000 |
81871 |
19980331 |
22.50000 |
81871 |
19980430 |
16.12500 |
81871 |
19980529 |
11.12500 |
81871 |
19980630 |
13.43750 |
81871 |
19980731 |
22.87500 |
81871 |
19980831 |
17.75000 |
81871 |
19980930 |
24.25000 |
81871 |
19981030 |
26.00000 |
|
|
Copyright © SAS Institute, Inc. All Rights Reserved.