

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 |