topic How to group the data for similar values in a reverse order ? in New SAS User

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

krishnaalla — Tue, 22 Jan 2019 03:41:39 GMT

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;

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

Reeza — Tue, 22 Jan 2019 03:43:28 GMT

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;

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

krishnaalla — Tue, 22 Jan 2019 03:50:50 GMT

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

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

Reeza — Tue, 22 Jan 2019 03:54:28 GMT

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