BookmarkSubscribeRSS Feed
Siddhartha
Calcite | Level 5
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
6 REPLIES 6
LinusH
Tourmaline | Level 20
Sorry, I can't see the logic. Please add some description of your problem.
/Linus
Data never sleeps
Siddhartha
Calcite | Level 5
The final output should be as follows:

4
5
6
7
8
9

Regards,
Siddhartha
Siddhartha
Calcite | Level 5
Yes, I need to get all non matching observations.

Thanks in advance.

Regards,
Siddhartha
LinusH
Tourmaline | Level 20
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;
Data never sleeps
data_null__
Jade | Level 19
[pre]if not(a and b);[/pre]
RickM
Fluorite | Level 6
I think you need to elaborate more. It almost looks like you want all non-matching obs except that 6 is in both datasets.
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1952 views
  • 0 likes
  • 4 in conversation