The SASEXCCM Interface Engine

Example 51.10 Retrieving Daily Group Time Series by the INDNO= Option

This example shows how to retrieve daily group time series by using the INDNO keys in the IND database that were found in Example 51.9.

title 'Retrieve Daily Group Time Series by INDNO';
libname _all_ clear;

libname crsp sasexccm
   "\\bb04smb01\thirdparty\lnx\crspdata\DIZ201006\"
   setid=440
   indno=1000012 indno=1000032
   itemlist="AINDG.*;ARETG.*;USDCNTG.*;USDVALG.*";

 data dgindts_all ( where=( caldt >= '29jun2010'd) );
    set crsp.dlygind_ts;
 run;

 proc print data=dgindts_all; run;

Output 51.10.1: Daily Group Indices Time Series by INDNO

Retrieve Daily Group Time Series by INDNO

Obs KYINDNO KEYSET_TAG CALDT AINDG ARETG USDCNTG USDVALG
1 1000012 1 20100629 7830.32 -0.027881 212 18621519.46
2 1000012 1 20100630 7818.16 -0.001553 212 18102340.54
3 1000012 2 20100629 2152.53 -0.029494 218 41076860.87
4 1000012 2 20100630 2138.40 -0.006568 218 39865355.36
5 1000012 3 20100629 2062.74 -0.030899 221 68226374.39
6 1000012 3 20100630 2050.86 -0.005761 221 66118281.02
7 1000012 4 20100629 1889.98 -0.034272 220 109562324.72
8 1000012 4 20100630 1876.58 -0.007090 220 105767265.49
9 1000012 5 20100629 2452.63 -0.037792 219 176873704.06
10 1000012 5 20100630 2426.61 -0.010609 219 170189222.39
11 1000012 6 20100629 2352.25 -0.036727 218 273518451.00
12 1000012 6 20100630 2326.55 -0.010923 218 263473022.01
13 1000012 7 20100629 1744.62 -0.036671 221 441993909.25
14 1000012 7 20100630 1728.12 -0.009454 221 425785496.41
15 1000012 8 20100629 1837.74 -0.034768 217 728682180.02
16 1000012 8 20100630 1823.06 -0.007989 217 703347314.23
17 1000012 9 20100629 1539.83 -0.037301 217 1551328686.76
18 1000012 9 20100630 1528.09 -0.007619 217 1493462838.15
19 1000012 10 20100629 687.77 -0.029865 219 7887915836.89
20 1000012 10 20100630 682.07 -0.008285 219 7652344301.36
21 1000032 1 20100629 50180.52 -0.028314 46 421298.09
22 1000032 1 20100630 49647.30 -0.010626 46 409369.47
23 1000032 2 20100629 9074.88 -0.018115 53 1027381.77
24 1000032 2 20100630 8999.49 -0.008307 53 1008770.94
25 1000032 3 20100629 7605.46 -0.021016 49 1357042.08
26 1000032 3 20100630 7647.77 0.005564 49 1328521.95
27 1000032 4 20100629 4864.93 -0.019350 49 1882198.23
28 1000032 4 20100630 4862.58 -0.000483 49 1845777.95
29 1000032 5 20100629 3830.96 -0.019162 52 2935672.46
30 1000032 5 20100630 3836.25 0.001382 52 2879419.36
31 1000032 6 20100629 1985.95 -0.023069 49 3471137.55
32 1000032 6 20100630 1994.63 0.004371 49 3391061.96
33 1000032 7 20100629 1737.15 -0.026127 50 5429238.78
34 1000032 7 20100630 1723.08 -0.008097 50 5287388.16
35 1000032 8 20100629 985.90 -0.043221 49 8751647.84
36 1000032 8 20100630 982.62 -0.003332 49 8373396.28
37 1000032 9 20100629 2012.69 -0.035989 47 13946079.35
38 1000032 9 20100630 2008.03 -0.002314 47 13444178.17
39 1000032 10 20100629 580.82 -0.034960 48 77397528.18
40 1000032 10 20100630 574.67 -0.010592 48 74691749.11