How to group the data for similar values in a reverse order ?

[krishnaalla]

 I want to group "AUS Vs WI" & "WI Vs AUS" 

data test;
infile datalines;
input Match $12.;
datalines;
AUS Vs WI
IND Vs SRI
AUS Vs WI
WI Vs AUS
IND Vs AUS
AUS Vs IND
SRI Vs IND
NZ Vs SA
SA Vs NZ
;
run;

proc print data=test;
run;

[Reeza]

What do you want as the output?

---

@krishnaalla wrote:

 I want to group "AUS Vs WI" & "WI Vs AUS" 

data test;
infile datalines;
input Match $12.;
datalines;
AUS Vs WI
IND Vs SRI
AUS Vs WI
WI Vs AUS
IND Vs AUS
AUS Vs IND
SRI Vs IND
NZ Vs SA
SA Vs NZ
;
run;

proc print data=test;
run;

---

[krishnaalla]

i want to group the values :

example: 

AUS Vs IND  having 10 values

IND Vs AUS  having 15 values

treat as a similar value and group it as one value. 

in need

IND Vs AUS count as 25 values

[Reeza · Accepted solution]

data want;
set test;
team1 = scan(match, 1);
team2 = scan(match, 3);
call sortc(team1, team2);
run;

proc freq data=want;
table team1*team2 / list;
run;

---

@krishnaalla wrote:

i want to group the values :

example: 

AUS Vs IND  having 10 values

IND Vs AUS  having 15 values

treat as a similar value and group it as one value. 

in need

IND Vs AUS count as 25 values

---