topic Re: swap the data in New SAS User

swap the data

BrahmanandaRao — Wed, 15 May 2019 07:24:26 GMT

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;

Required Output like below

GIVEN DATA	REQUIRED O/P
AUS Vs WI	WI Vs AUS
IND Vs SRI	SRI Vs IND
AUS Vs WI	WI Vs AUS
WI Vs AUS	AUS Vs WI
IND Vs AUS	AUS Vs IND
AUS Vs IND	IND Vs AUS
SRI Vs IND	IND Vs SRI
NZ Vs SA	SA Vs NZ
SA Vs NZ	NZ Vs SA

Re: swap the data

PeterClemmensen — Wed, 15 May 2019 07:28:56 GMT

Do like this

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;

data test2;
   set test;
   name=prxchange('s/(\w+) Vs (\w+)/$2 Vs $1/', -1, Match);
run;

Re: swap the data

Kurt_Bremser — Wed, 15 May 2019 07:32:17 GMT

Or this:

data have;
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;

data want;
set have;
match = catx(' ',scan(match,3),scan(match,2),scan(match,1));
run;

Re: swap the data

BrahmanandaRao — Wed, 15 May 2019 07:39:38 GMT

Thank you for solution

Regards,

ANAND

Re: swap the data

BrahmanandaRao — Wed, 15 May 2019 07:41:13 GMT

Thank you sir for your support

Regards,

Anand