want to remove perios after the name

[Smitha9]

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

[Shmuel]

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

[Reeza]

You can search the functions under the "Character" category for one that meets your need. 

COMPRESS(), COMPBL(), TRANSLATE() are some options.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarg...

---

@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

---

[Smitha9]

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

[ballardw]

Scan will also use periods as delimiter by default just like you "letters before comma" question.

[Shmuel]

this is a duplicate of

https://communities.sas.com/t5/New-SAS-User/want-to-remove-perios-after-the-name/m-p/697727 

[Reeza]

---

@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.