Hi,
I have a dataset:
Ali.
Sara.
Maya.
Bran.
I want to remove the period after the name;
want dataset:
Ali
Sara
Maya
Bran
thank you in advance
You can use compress function - to remove periods
name = compress(name,'.');
or you can use scan function with period as the delimiter
name = scan(name,1,'.');
You can search the functions under the "Character" category for one that meets your need.
COMPRESS(), COMPBL(), TRANSLATE() are some options.
@Smitha9 wrote:
Hi,
I have a dataset:
Ali.
Sara.
Maya.
Bran.
I want to remove the period after the name;
want dataset:
Ali
Sara
Maya
Bran
thank you in advance
Hi,
I have a dataset:
Ali.
Sara.
Maya.
Bran.
I want to remove the period after the name;
want dataset:
Ali
Sara
Maya
Bran
thank you in advance
Scan will also use periods as delimiter by default just like you "letters before comma" question.
this is a duplicate of
https://communities.sas.com/t5/New-SAS-User/want-to-remove-perios-after-the-name/m-p/697727
@Shmuel wrote:
this is a duplicate of
https://communities.sas.com/t5/New-SAS-User/want-to-remove-perios-after-the-name/m-p/697727
I've merged them.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.