|
1000000 |
19990129 |
0.012419 |
1000000 |
19990226 |
-0.024179 |
1000000 |
19990331 |
0.028591 |
1000001 |
19990129 |
-0.007822 |
1000001 |
19990226 |
-0.041127 |
1000001 |
19990331 |
0.015204 |
This example selects two companies from the CCM database.
data companies;
permco=8045; output; /* Oracle */
permco=20483; output; /* Citigroup */
run;
libname comp2 sasecrsp "%sysget(CRSP_CST)"
setid=200
inset='companies,PERMCO,PERMCO'
range='20040101-20040531';
title2 'Using the Link Info of Selected PERMCOs';
proc print data=comp2.link label;
run;
title3 'To Show Dividends Per Share for Oracle and Citigroup';
proc print data=comp2.div label;
run;
Output 33.4.2 shows the result of selecting two companies from the CCM database by using the CCM LINK data and the INSET= option.
Output 33.4.2
CCM LINK Data Extracted By Using INSET= Option
|
12142 |
19860312 |
20991231 |
10104 |
8045 |
LC |
BBB |
3243 |
19861029 |
20991231 |
70519 |
20483 |
LC |
BBB |
Output 33.4.3 shows the result of selecting two companies from the CCM database by using the CCM DIV data and the INSET= option.
Output 33.4.3
CCM DIV Data Extracted By Using INSET= Option
|
12142 |
20040130 |
0.0000 |
12142 |
20040227 |
0.0000 |
12142 |
20040331 |
0.0000 |
12142 |
20040430 |
0.0000 |
12142 |
20040528 |
0.0000 |
3243 |
20040130 |
0.4000 |
3243 |
20040227 |
0.0000 |
3243 |
20040331 |
0.0000 |
3243 |
20040430 |
0.4000 |
3243 |
20040528 |
0.0000 |
This example selects three securities from the Stock database by using TICKERs in the INSET= option for data extraction.
data securities;
ticker='BAC'; output; /* Bank of America */
ticker='DUK'; output; /* Duke Energy */
ticker='GSK'; output; /* GlaxoSmithKline */
run;
libname sec3 sasecrsp "%sysget(CRSP_MSTK)"
setid=20
inset='securities,TICKER,TICKER'
range='19970820-19970920';
title2 'PERMNOs and General Header Info of Selected TICKERs';
proc print data=sec3.stkhead(keep=permno htick htsymbol) label;
run;
title3 'Average Price for Bank of America, Duke and GlaxoSmithKline';
proc print data=sec3.prc label;
run;
Output 33.4.4 shows the STK header data for the TICKERs specified by using the INSET= option.
Output 33.4.4
STK Header Data Extracted Using INSET= Option
|
59408 |
3151 |
60003150 |
4005 |
1 |
11 |
6021 |
19721229 |
20061229 |
100 |
06050510 |
BAC |
BANK OF AMERICA CORP |
BAC |
522110 |
N |
A |
R |
27959 |
20608 |
0 |
0 |
1 |
11 |
4911 |
19610731 |
20061229 |
100 |
26441C10 |
DUK |
DUKE ENERGY CORP NEW |
DUK |
221122 |
N |
A |
R |
75064 |
1973 |
60001972 |
2523 |
1 |
31 |
2834 |
19721229 |
20061229 |
100 |
37733W10 |
GSK |
GLAXOSMITHKLINE PLC |
GSK |
325412 |
N |
A |
R |
Output 33.4.5 shows the STK price data for the TICKERs specified by using the INSET= option.
Output 33.4.5
STK Price Data Extracted Using INSET= Option
|
59408 |
19970829 |
59.75000 |
27959 |
19970829 |
48.43750 |
75064 |
19970829 |
39.93750 |
Copyright
© 2008 by SAS Institute Inc., Cary, NC, USA. All
rights reserved.