Sas common variable

[archita]

I have two datasets with common variables station and station number in both.. I want to see distinct common station with same city name and also common station with different city name.please help.

[PeterClemmensen]

Please provide some sample data.

[archita]

Test1
Alex 301
Tor 78
Seine 200
Ron 450
Alex 301
Test2.
Ran 65
Tor 78
Alex 209
Manik 34
Tor 44

[PeterClemmensen]

And given this data, what does your desired result look like?

[archita]

I want to see common variables with same records and also common variables with different record
Like Alex 301 I'm first case and
Alex 209 for second one

[Kurt_Bremser · Accepted solution]

Run this:

data Test1;
input name $ number;
datalines;
Alex 301
Tor 78
Seine 200
Ron 450
Alex 301
;

data Test2;
input name $ number;
datalines;
Ran 65
Tor 78
Alex 209
Manik 34
Tor 44
;

proc sort data=test1;
by name;
run;

proc sort data=test2;
by name;
run;

data
  match
  nomatch
  miss_1
  miss_2
;
merge
  test1 (in=t1 rename=(number=number1))
  test2 (in=t2 rename=(number=number2))
;
by name;
if t1 and t2
then do;
  if number1 = number2
  then output match;
  else output nomatch;
end;
else if t2
then output miss_1;
else output miss_2;
run;

and see if the results are what you need, otherwise tell us what you need to be different.

[archita]

Thank you working fine .