Hi, I am using SAS 9.3.
Does anyone have suggestions to resolve the following issue?
Now, I have one variable recorded as: Birthday Sex Height Weight
and the expected result is: Birthday, Sex, Height, Weight
JC
data x;
x='Birthday Sex Height Weight';
y=prxchange('s/\s+/, /',-1,strip(x));
run;
proc print;run;
data x;
x='Birthday Sex Height Weight';
y=prxchange('s/\s+/, /',-1,strip(x));
run;
proc print;run;
It works. Thank for your help!
Is 's/\s+/,/' fixed?
Can I use PRXCHANGE in macro? Perhaps, %let a=%sysfunc(prxchange('s/\s+/,/',-1,strip(x))); ?
JC
Yes.I add a white blank after comma.
%let x=sex weight height;
%let a=%sysfunc(prxchange(%str(s/\s+/, /),-1,&x));
%put &a ;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.