DATA Step, Macro, Functions and more

Conditioanal merging

Reply
Occasional Contributor
Posts: 9

Conditioanal merging

Hi all,

 

I have two dataset data1 and data2.

 

data1.

store_postcode

1

2

3

4

5

6

7

8

9

 

 

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.

Super User
Super User
Posts: 9,227

Re: Conditioanal merging

Posted in reply to apxprdtr10

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?  

Occasional Contributor
Posts: 9

Re: Conditioanal merging

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

Super User
Super User
Posts: 9,227

Re: Conditioanal merging

Posted in reply to apxprdtr10

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. 

Super User
Posts: 13,084

Re: Conditioanal merging

Posted in reply to apxprdtr10

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.

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