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

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

MaryA_Marion — Wed, 02 Oct 2019 13:42:34 GMT

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

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

Reeza — Tue, 01 Oct 2019 15:55:12 GMT

Show your full log please.

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

MaryA_Marion — Wed, 02 Oct 2019 13:38:21 GMT

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

Reeza — Tue, 01 Oct 2019 16:29:41 GMT

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

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

ballardw — Wed, 02 Oct 2019 16:02:00 GMT

@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.