11-14-2014 07:15 AM
I am trying to merge two data sets (something I have done 500 times). The field I am trying to add to the first from the second is not copying correctly in that the values are not matching correctly based on the 'by' variable. I have tried it several different ways and nothing seems to work. Anyone see anything? Its the AppearCount variable that I want to add and the values for it are not matching. Also the second data set (appearances2bt1) is actually a subset of the first.
proc sort data=appearances2b;
proc sort data=appearances2bt1;
length EventType $ 50;
merge appearances2b (in=a) appearances2bt1 (keep=docket_id AppearCount);
if event in ("AAD","AHR","ACT","AIQ","ANE","ANH","ACD","AHY","ASJ")
if event in ("DDD","DRR","DPP","DTP","DAJ","DSP","DDS","DOR",
"DWD") then EventType="Disposition";
if event in ("XCA","XRF","XRL","XGA","XAP","XRM","XOT") then EventType="Exit";
if event in ("PHR","PHC") then EventType="PermanencyHearing";
drop AGEOUT IY NYC FCOUNT OCOUNT SCOUNT TCOUNT PCOUNT HCOUNT
DURCAT_ADJUD_DISPO1 DURCAT_ADJUD1 DUR_PL1 DURCAT_PL1
PLACE_CAT1 TADJUD_FLAG CENSOR_TADJUD1 CENSOR_TADJUD1 DURCAT_TADJUD_TDISPO1 DURCAT_TADJUD_TDISPO1
durmod durmod_cat state link ageout count fcount_notpr place_end1 help durmoa durmoa_cat exit_pl1 stop_pl1
11-14-2014 07:53 AM
Are you sure that you do not have an AppearCount in appearances2b already?
11-14-2014 08:55 AM
Yes, KurtBremser has made the correct observation.
Tell us what you are really trying to do, because the two tables are equivalent. They have the same number of rows, and both have the variables docket_id and AppearCount with the exact same values...unless you are doing some additional processing on appearances2bt1 that you have not shown.
Assuming the latter, just drop AppearCount from appearances2b and you should get what you are expecting.