topic Re: Merging the dataset in SAS Programming

Merging the dataset

Siddhartha — Fri, 20 Aug 2010 15:00:42 GMT

I have a two datasets.I need to get the output as follows:

data one;
input x;
1
2
3
4
5
6;
run;
data two;
input x;
1
3
6
7
8
9
;
run;

the ouput is as follows:

4
5
6
7
8
9

Re: Merging the dataset

LinusH — Fri, 20 Aug 2010 15:11:37 GMT

Sorry, I can't see the logic. Please add some description of your problem.
/Linus

Re: Merging the dataset

RickM — Fri, 20 Aug 2010 15:13:44 GMT

I think you need to elaborate more. It almost looks like you want all non-matching obs except that 6 is in both datasets.

Re: Merging the dataset

Siddhartha — Fri, 20 Aug 2010 15:14:00 GMT

The final output should be as follows:

4
5
6
7
8
9

Regards,
Siddhartha

Re: Merging the dataset

Siddhartha — Fri, 20 Aug 2010 15:16:10 GMT

Yes, I need to get all non matching observations.

Thanks in advance.

Regards,
Siddhartha

Re: Merging the dataset

LinusH — Fri, 20 Aug 2010 15:22:42 GMT

I geuss that you want "2" as well?

data three;
merge one(in=a) two(in=b);
by x;
if a and not b or not a and b;
run;

Re: Merging the dataset

data_null__ — Fri, 20 Aug 2010 15:44:52 GMT

[pre]if not(a and b);[/pre]