The output includes a variable that tells me which of the two data sets the observation is coming from. It also says which are coming from both. I would like to keep only those rows which have "BOTH" as a source. What is the best way to do this?
| 421 | ACRE | ANNUAL | 2012 | 0.7119757952 |
And here is the log:
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
70
71 *MERGE statement has more than one data set with repeats of BY values;
72 proc sort data=paper.CSRP_annual_returns
73 out=paper.CSRP_annual_returns2
74 nodupkey;
75 by ticker;
76 run;
NOTE: There were 53176 observations read from the data set PAPER.CSRP_ANNUAL_RETURNS.
NOTE: 42661 observations with duplicate key values were deleted.
NOTE: The data set PAPER.CSRP_ANNUAL_RETURNS2 has 10515 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
user cpu time 0.01 seconds
system cpu time 0.01 seconds
memory 6126.06k
OS Memory 36452.00k
Timestamp 04/01/2018 07:47:46 PM
Step Count 61 Switch Count 2
Page Faults 0
Page Reclaims 876
Page Swaps 0
Voluntary Context Switches 46
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 528
77
78 *Merge CEO data and firm data;
79 DATA paper.ceo_firm ;
80 length ticker $5 source $10;
81 MERGE
82 paper.CSRP_annual_returns2 (in=in1)
83 paper.compustat_execucomp4 (in=in2)
84 ;
85 BY ticker;
86 if in1 and in2 then source='BOTH';
87 else if in1 then source='ANNUAL';
88 else source='EXECCOMP';
89 RUN;
NOTE: There were 10515 observations read from the data set PAPER.CSRP_ANNUAL_RETURNS2.
NOTE: There were 13346 observations read from the data set PAPER.COMPUSTAT_EXECUCOMP4.
NOTE: The data set PAPER.CEO_FIRM has 21807 observations and 109 variables.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
user cpu time 0.02 seconds
system cpu time 0.05 seconds
memory 4222.00k
OS Memory 35504.00k
Timestamp 04/01/2018 07:47:47 PM
Step Count 62 Switch Count 2
Page Faults 0
Page Reclaims 738
Page Swaps 0
Voluntary Context Switches 1472
Involuntary Context Switches 1
Block Input Operations 544
Block Output Operations 88840
90
91 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
103
Thanks for the help!
Click image to register for webinar
