How to keep dot(.) After every two letters including spaces - SAS Support Communities

Fluorite | Level 6

Fluorite | Level 6

How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 03:29 AM (2093 views)

Data ex;
Name='sas community software';
Run;
How to do like see below
New_name='sa.s . Co.mm.un.it.y .so.ft.wa.re'

5 REPLIES 5

Super User

Super User

Re: How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 03:33 AM (2090 views) | In reply to thanikondharish

Please show the code you already tried.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Opal | Level 21

Opal | Level 21

Re: How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 04:40 AM (2076 views) | In reply to thanikondharish

data ex;
  name='sas community software';
  length new_name $40;
  new_name=prxchange('s/(..)(?!$)/\1./oi',-1,strip(name));
run;

Fluorite | Level 6

Fluorite | Level 6

Re: How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 05:01 AM (2072 views) | In reply to Patrick

Can you explain prxchange uses

Opal | Level 21

Opal | Level 21

Re: How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 05:09 AM (2067 views) | In reply to thanikondharish

http://support.sas.com/documentation/cdl//en/lefunctionsref/69762/HTML/default/viewer.htm#n0r8h2fa8d...

https://go.documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p1vz3ljudbd756n19502acxazevk....

https://go.documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0s9ilagexmjl8n1u7e1t1jfnzlk....

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: How to keep dot(.) After every two letters including spaces

Posted 05-17-2019 05:25 AM (2062 views) | In reply to Patrick

Impressing!