How to insert one symbol between characters in the sequence?

[JohnChen_TW]

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

[gamotte]

Hello,

if I understand correctly, you have a variable, say INFO that takes values such as "02/12 M 60 120" and you would like to have four distinct variables.
Then you can use the scan function

birthday=scan(INFO,1," ");
sex=scan(INFO,2," ");
...

[Ksharp · Accepted solution]

data x;
x='Birthday Sex Height Weight';
y=prxchange('s/\s+/, /',-1,strip(x));
run;
proc print;run;

[JohnChen_TW]

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

[Ksharp]

Yes.I add a white blank after comma.

 %let x=sex weight height;
 %let a=%sysfunc(prxchange(%str(s/\s+/, /),-1,&x)); 
 
 %put &a ;

[JohnChen_TW]

It works!!!!
Thank you very much!!!!

JC