DATA Step, Macro, Functions and more

Data set merge

Reply
Regular Contributor
Posts: 216

Data set merge

Hi

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.

Paul

proc sort data=appearances2b;
by docket_id;
run;


proc sort data=appearances2bt1;
by docket_id;
run;

data AppearanceAttendDen;
length EventType $ 50;
merge appearances2b (in=a) appearances2bt1 (keep=docket_id AppearCount);
if a;
by docket_id;


if event in ("AAD","AHR","ACT","AIQ","ANE","ANH","ACD","AHY","ASJ")
then EventType="Adjudication";

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
place1y;

run;

Super User
Posts: 7,832

Re: Data set merge

Are you sure that you do not have an AppearCount in appearances2b already?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Frequent Contributor
Posts: 91

Re: Data set merge

Posted in reply to KurtBremser

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.

Contributor
Posts: 49

Re: Data set merge

Hi,

I met your same problem with the merge statement,

In this post we talk about the merge statement in SAS:

Ask a Question
Discussion stats
  • 3 replies
  • 214 views
  • 0 likes
  • 4 in conversation