How to Merge datasets to ID's in both datasets. Error message uninitialized dataset?

[MaryA_Marion]

Hello,

Everything works until I attempt to merge.  No error is given. fiveb has 0 observations.

%mysort4(nypop,nypop_s,A);
%mysort4(nonnycvotes,nonnycvotes_s,A);

data nypop_s; set nypop_s; run;
proc print data=nypop_s(firstobs= 1 obs= 10) label; run;

data nonnycvotes_s; set nonnycvotes_s (rename=( L=L2 M=M2 U=U2) );
run;
proc print data=nonnycvotes_s(firstobs= 1 obs= 10) label; run;

data fiveb;
merge nypop_s (in=makeup1) nonnycvotes_s (in=makeup2);
by A;
if makeup1 and makeup2;
run;

Thank you.

Mary A. Marion

[Reeza]

Show your full log please.

[Reeza]

I can't download attachments, please post information directly into the forum or someone else will assist.

[ballardw · Accepted solution]

---

@MaryA_Marion wrote:

Hello,

Everything works until I attempt to merge.  No error is given. fiveb has 0 observations.

%mysort4(nypop,nypop_s,A);
%mysort4(nonnycvotes,nonnycvotes_s,A);

data nypop_s; set nypop_s; run;
proc print data=nypop_s(firstobs= 1 obs= 10) label; run;

data nonnycvotes_s; set nonnycvotes_s (rename=( L=L2 M=M2 U=U2) );
run;
proc print data=nonnycvotes_s(firstobs= 1 obs= 10) label; run;

data fiveb;
merge nypop_s (in=makeup1) nonnycvotes_s (in=makeup2);
by A;
if makeup1 and makeup2;
run;

Thank you.

Mary A. Marion

---

With this code:

data fiveb;
merge nypop_s (in=makeup1) nonnycvotes_s (in=makeup2);
by A;
if makeup1 and makeup2;
run;

most likely there are NO matching values of the variable A in the two sets.

Consider that the first value in the nonnycvoters  has a value of "Albany" and the first in nypopulation is "Albany County" it is pretty obvious that the values do not match.