Example 51.2 Retrieving SALE Data for Multiple Companies
This example shows how to retrieve several data items for several GVKEYs. Note how the item offtitl
is not an annual item and is stored in its own member. The default (standard) keyset is used for all items. For brevity,
a subset of the data that contains the most recent figures is specified by the WHERE statement.
title 'Retrieve Sales, Revenue, Liabilities, and Officer data for IBM and MSFT';
libname _all_ clear;
libname crsp sasexccm "\\bb04smb01\thirdparty\lnx\crspdata\cmz201201\"
setid=250
gvkey=6066
gvkey=12141
itemlist="sale;revt;lct;offtitl";
data recentannitems;
set crsp.annitem;
where datadate >= '1jan2000'd;
proc print data=recentannitems;
proc print data=crsp.offtitl;
run;
Output 51.2.1: Data Items for IBM and Microsoft
6066 |
STD |
20001229 |
88396.0000 |
88396.0000 |
36406.0000 |
6066 |
STD |
20011231 |
85866.0000 |
85866.0000 |
35119.0000 |
6066 |
STD |
20021231 |
81186.0000 |
81186.0000 |
34550.0000 |
6066 |
STD |
20031231 |
89131.0000 |
89131.0000 |
37900.0000 |
6066 |
STD |
20041231 |
96293.0000 |
96293.0000 |
39798.0000 |
6066 |
STD |
20051230 |
91134.0000 |
91134.0000 |
35152.0000 |
6066 |
STD |
20061229 |
91424.0000 |
91424.0000 |
40091.0000 |
6066 |
STD |
20071231 |
98786.0000 |
98786.0000 |
44310.0000 |
6066 |
STD |
20081231 |
103630.0000 |
103630.0000 |
42435.0000 |
6066 |
STD |
20091231 |
95758.0000 |
95758.0000 |
36002.0000 |
6066 |
STD |
20101231 |
99871.0000 |
99871.0000 |
40562.0000 |
12141 |
STD |
20000630 |
22956.0000 |
22956.0000 |
9755.0000 |
12141 |
STD |
20010629 |
25296.0000 |
25296.0000 |
11132.0000 |
12141 |
STD |
20020628 |
28365.0000 |
28365.0000 |
12744.0000 |
12141 |
STD |
20030630 |
32187.0000 |
32187.0000 |
13974.0000 |
12141 |
STD |
20040630 |
36835.0000 |
36835.0000 |
14969.0000 |
12141 |
STD |
20050630 |
39788.0000 |
39788.0000 |
16877.0000 |
12141 |
STD |
20060630 |
44282.0000 |
44282.0000 |
22442.0000 |
12141 |
STD |
20070629 |
51122.0000 |
51122.0000 |
23754.0000 |
12141 |
STD |
20080630 |
60420.0000 |
60420.0000 |
29886.0000 |
12141 |
STD |
20090630 |
58437.0000 |
58437.0000 |
27034.0000 |
12141 |
STD |
20100630 |
62484.0000 |
62484.0000 |
26147.0000 |
12141 |
STD |
20110630 |
69943.0000 |
69943.0000 |
28774.0000 |
6066 |
1911113 |
CE |
Ms. Virginia M. Rometty |
6066 |
1911113 |
DI |
Ms. Virginia M. Rometty |
6066 |
1911113 |
PR |
Ms. Virginia M. Rometty |
6066 |
1911114 |
CB |
Mr. Samuel J. Palmisano |
6066 |
1911114 |
DI |
Mr. Samuel J. Palmisano |
6066 |
1911115 |
CF |
Mr. Mark Loughridge |
6066 |
1911116 |
TO |
Mr. Rodney C. Adkins |
12141 |
1873964 |
CE |
Mr. Steven A. Ballmer |
12141 |
1873964 |
DI |
Mr. Steven A. Ballmer |
12141 |
1873965 |
CB |
Mr. William Henry Gates III |
12141 |
1873965 |
DI |
Mr. William Henry Gates III |
12141 |
1873966 |
CO |
Mr. Brain Kevin Turner |
12141 |
1873967 |
CF |
Mr. Peter S. Klein |