data ds;
infile datalines;
input var1 var2$10.;
datalines;
201 Pakistan
206 Bangladesh
209 Russia
208 China
245 In
862 L
;
run;
what i need is
Paxxstan
baxxladesh
Ruxxia
chxxa
In
L
data want;
set have;
substr(country,3,1)='x';
substr(country,4,1)='x';
run;
One case that is missing from your example: Sri
Should that become Srx or should it become Srxx?
At any rate, here are the basic tools that you can modify if needed:
if length(var2) > 2 then substr(var2, 3, 2) = 'xx';
You can use substr() function along with IF condition:
data want;
set ds;
if length(var2)<=2 then new_var=var2;
else if length(var2)=3 then new_var=substr(var2,1,2)||"x"||substr(var2,5);
else new_var=substr(var2,1,2)||"xx"||substr(var2,5);
run;
Another alternate solution will be using the Perl expression:
data want;
set ds;
new_var=substr(var2,1,2)||prxchange('s/[a-z][a-z]/xx/i',1,substr(var2,3));
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.