topic Re: Conditioanal merging in SAS Programming

Conditioanal merging

apxprdtr10 — Fri, 04 May 2018 09:37:05 GMT

Hi all,

I have two dataset data1 and data2.

data1.

store_postcode

data2.

store_postcode price month

2 32 1

5 65 3

3 87 2

1 89 3

6 56 5

8 45 7

4 67 4

7 49 8

Now i want to merge dataset2 in dataset1 by store_postcode.

Thanks.

RW9 — Fri, 04 May 2018 09:51:40 GMT

Sort d1 and d2 by store_postcode then:

data want;
  merge d1 d2;
  by store_postcode;
run;

Is that your question as I don't see anything conditional?

apxprdtr10 — Fri, 04 May 2018 09:54:04 GMT

as you can see there is no store_postcode named 9 in dataset2. and that's where i want conditional merging.

RW9 — Fri, 04 May 2018 09:57:41 GMT

This does not mean anything to me. Do you mean you only want values which appear in one dataset? If so then add:

data want;
  merge d1 (in=a) d2 (in=b);
  by store_postcode;
  if a and b;
run;

The above will keep only observations where data is in both datasets. You could do:

if a;

For only those records in the first, or

if b;

for those only in the second.

ballardw — Fri, 04 May 2018 17:34:36 GMT

Show your desired output. The example is small enough that should not be difficult.

A description that can be interpreted in multiple ways leads to lots of clarifying questions.