topic Re: Delete Period after the name in New SAS User

want to remove perios after the name

Smitha9 — Mon, 09 Nov 2020 21:21:02 GMT

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

Delete Period after the name

Smitha9 — Mon, 09 Nov 2020 21:34:53 GMT

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

Re: want to remove perios after the name

Shmuel — Mon, 09 Nov 2020 21:35:04 GMT

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

Re: want to remove perios after the name

Reeza — Mon, 09 Nov 2020 21:36:21 GMT

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&docsetTarget=n01f5qrjoh9h4hn1olbdpb5pr2td.htm&locale=da

@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

Re: Delete Period after the name

ballardw — Mon, 09 Nov 2020 21:38:12 GMT

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

Re: Delete Period after the name

Shmuel — Mon, 09 Nov 2020 21:38:28 GMT

this is a duplicate of

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

Re: Delete Period after the name

Reeza — Mon, 09 Nov 2020 21:38:55 GMT

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