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.
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?
as you can see there is no store_postcode named 9 in dataset2. and that's where i want conditional merging.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.