topic Re: How to insert one symbol between characters in the sequence? in SAS Programming

How to insert one symbol between characters in the sequence?

JohnChen_TW — Wed, 29 Mar 2017 10:26:37 GMT

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

Re: How to insert one symbol between characters in the sequence?

gamotte — Wed, 29 Mar 2017 10:43:48 GMT

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," ");
...

Re: How to insert one symbol between characters in the sequence?

Ksharp — Wed, 29 Mar 2017 10:48:25 GMT

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

Re: How to insert one symbol between characters in the sequence?

JohnChen_TW — Wed, 29 Mar 2017 10:59:34 GMT

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))); ?

Re: How to insert one symbol between characters in the sequence?

Ksharp — Wed, 29 Mar 2017 11:08:31 GMT

Yes.I add a white blank after comma.

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

Re: How to insert one symbol between characters in the sequence?

JohnChen_TW — Wed, 29 Mar 2017 11:30:34 GMT

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

JC