SAS programming - Remove duplicates

[Pranshu]

Hi All,

I have the following data based on distance between the cities.

Source	Destination	Distance
USA	UK	1000
USA	Spain	200
UK	USA	1000
Germany	Spain	500
Spain	USA	200

I want to remove the duplicates where source and destination are same. For Example USA to UK will be same as UK to USA and hence the duplicate value needs to be removed.

Following is the desired output.

Source	Destination	Distance
USA	UK	1000
USA	Spain	200
Germany	Spain	500

[tomrvincent]

concatenate source and destination in alphabetical order and then pick max distance for each pair.

[Ksharp · Accepted solution]

data have;
infile cards expandtabs;
input Source $ Destination $ Distance;
cards;
USA	UK	1000
USA	Spain	200
UK	USA	1000
Germany	Spain	500
Spain	USA	200
;
run;
data temp;
 set have;
 call sortc(Source,Destination);
run;
proc sort data=temp out=want nodupkey;
by Source Destination;
run;
proc print;run;

[Pranshu]

Thanks for your response. This really solved my query.

[Tom]

Why not just take those where Source < Destination?

[Ksharp]

If there is only one obs, and Source > Destination?

[Tom]

Add
call sortc(source,destination);
Before IF statement.