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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.