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 |