The SASEXCCM Interface Engine

Example 40.11 Retrieving Monthly Group Time Series by the INDNO= Option

This example shows how to retrieve monthly group time series by using the INDNO= option. 

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

libname crsp sasexccm
   "\\tappan\crsp1\data201008_little\MIZ201006\"
   setid=400
   indno=1000357
   itemlist="MTRETG.*;MUSDCNTG.*;MUSDVALG.*";

 data mgindts_all ( where=( mcaldt >= '01apr2010'd) );
    set crsp.mthgind_ts;
 run;

 proc contents data=mgindts_all; run;
 proc print data=mgindts_all; run;

Output 40.11.1: Monthly Group Indices Time Series by INDNO

Retrieve Monthly Group Time Series by INDNO

The CONTENTS Procedure

Data Set Name WORK.MGINDTS_ALL Observations 51
Member Type DATA Variables 6
Engine V9 Indexes 0
Created 03/14/2014 15:09:10 Observation Length 64
Last Modified 03/14/2014 15:09:10 Deleted Observations 0
Protection   Compressed NO
Data Set Type   Sorted NO
Label      
Data Representation WINDOWS_32    
Encoding wlatin1 Western (Windows)    

Engine/Host Dependent Information
Data Set Page Size 65536
Number of Data Set Pages 1
First Data Page 1
Max Obs per Page 1021
Obs in First Data Page 51
Number of Data Set Repairs 0
ExtendObsCounter YES
Filename C:\Users\saskff\AppData\Local\Temp\SAS Temporary Files\_TD7452_D79286_\mgindts_all.sas7bdat
Release Created 9.0401M2
Host Created W32_7PRO

Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
2 KEYSET_TAG Char 24 6. 6. KEYSET
1 KYINDNO Num 8 7. 7. Indno
3 MCALDT Num 8 YYMMDDN8. YYMMDD8. Caldt
4 MTRETG Num 8 11.6 11.6 Tret
5 MUSDCNTG Num 8 8. 8. Usdcnt
6 MUSDVALG Num 8 15.2 15.2 Usdval

Retrieve Monthly Group Time Series by INDNO

Obs KYINDNO KEYSET_TAG MCALDT MTRETG MUSDCNTG MUSDVALG
1 1000357 1 20100430 0.008174 175 8536273485.00
2 1000357 1 20100528 -0.080409 175 8591982134.00
3 1000357 1 20100630 -0.049665 175 7875937725.00
4 1000357 2 20100430 0.027565 185 1788689604.00
5 1000357 2 20100528 -0.075078 185 1840767431.00
6 1000357 2 20100630 -0.050972 185 1704852934.00
7 1000357 3 20100430 0.040804 190 932695901.00
8 1000357 3 20100528 -0.069991 188 969616974.00
9 1000357 3 20100630 -0.060083 187 895650676.00
10 1000357 4 20100430 0.037353 184 564387964.00
11 1000357 4 20100528 -0.079216 183 582823225.00
12 1000357 4 20100630 -0.070191 183 537053252.00
13 1000357 5 20100430 0.042394 227 478255773.00
14 1000357 5 20100528 -0.081422 228 500248663.00
15 1000357 5 20100630 -0.057584 227 457590748.00
16 1000357 6 20100430 0.057838 222 322738641.00
17 1000357 6 20100528 -0.078382 222 343700243.00
18 1000357 6 20100630 -0.081953 222 317307907.00
19 1000357 7 20100430 0.050365 292 287694406.00
20 1000357 7 20100528 -0.066656 291 301676691.00
21 1000357 7 20100630 -0.071452 292 283193837.00
22 1000357 8 20100430 0.065176 358 220136974.00
23 1000357 8 20100528 -0.075101 355 233544237.00
24 1000357 8 20100630 -0.071157 354 215763356.00
25 1000357 9 20100430 0.069557 514 180205516.00
26 1000357 9 20100528 -0.083660 514 193398849.00
27 1000357 9 20100630 -0.078070 520 180564497.00
28 1000357 10 20100430 0.096078 1374 134793898.00
29 1000357 10 20100528 -0.087666 1371 149100089.00
30 1000357 10 20100630 -0.079349 1368 137743847.00
31 1000357 11 20100430 0.011533 360 10324963089.00
32 1000357 11 20100528 -0.079468 360 10432749564.00
33 1000357 11 20100630 -0.049897 360 9580790659.00
34 1000357 12 20100430 0.040203 601 1975339638.00
35 1000357 12 20100528 -0.075396 599 2052688862.00
36 1000357 12 20100630 -0.062350 597 1890294676.00
37 1000357 13 20100430 0.057194 872 830570020.00
38 1000357 13 20100528 -0.073486 868 878921171.00
39 1000357 13 20100630 -0.075456 868 816265100.00
40 1000357 14 20100430 0.080906 1888 314999414.00
41 1000357 14 20100528 -0.085404 1885 342498939.00
42 1000357 14 20100630 -0.078624 1888 318308344.00
43 1000357 15 20100430 0.016137 961 12300302728.00
44 1000357 15 20100528 -0.078799 959 12485438427.00
45 1000357 15 20100630 -0.051949 957 11471085335.00
46 1000357 16 20100430 0.063714 2760 1145569435.00
47 1000357 16 20100528 -0.076828 2753 1221420110.00
48 1000357 16 20100630 -0.076345 2756 1134573445.00
49 1000357 17 20100430 0.020191 3721 13445872162.00
50 1000357 17 20100528 -0.078623 3712 13706858536.00
51 1000357 17 20100630 -0.054145 3713 12605658779.00