topic Re: Sas common variable in SAS Programming

Sas common variable

archita — Tue, 01 Dec 2020 09:08:16 GMT

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.

Re: Sas common variable

PeterClemmensen — Tue, 01 Dec 2020 09:50:28 GMT

Please provide some sample data.

Re: Sas common variable

archita — Tue, 01 Dec 2020 10:06:17 GMT

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

Re: Sas common variable

PeterClemmensen — Tue, 01 Dec 2020 10:09:44 GMT

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

Re: Sas common variable

archita — Tue, 01 Dec 2020 10:25:12 GMT

Re: Sas common variable

archita — Tue, 01 Dec 2020 10:27:19 GMT

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

Re: Sas common variable

Kurt_Bremser — Tue, 01 Dec 2020 10:59:37 GMT

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.

Re: Sas common variable

archita — Tue, 01 Dec 2020 11:51:32 GMT

Thank you working fine .