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 ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.