topic Re: HOW TO INSERT DELIMITER IN A SRING in SAS Programming

HOW TO INSERT DELIMITER IN A SRING

saidatta — Fri, 07 May 2021 15:09:56 GMT

I'm a learner of SAS interested in pursuing the career towards it so please help me. As i mentioned above can somebody please explain how to insert delimiter in a string like example asdf@gmail.com to asdf-@gmail.com by not breaking it into three variables like a=asdf b=@ c=gmail.com.

this is my question please help me im stuck

Re: HOW TO INSERT DELIMITER IN A SRING

sbxkoenk — Fri, 07 May 2021 15:33:46 GMT

Hello,

Look here:

Inserting a substring into a SAS string
By Leonid Batkhan on SAS Users February 15, 2021

https://blogs.sas.com/content/sgf/2021/02/15/inserting-a-substring-into-a-sas-string/

Have a nice weekend,

Koen

Re: HOW TO INSERT DELIMITER IN A SRING

Tom — Fri, 07 May 2021 15:39:56 GMT

For that simple example you can with do a replace:

If you know there are two and only two "words" separated by @ you can use scan() to parse it and catx() to build it back.

data test;
  length have want1-want2 $100;
  have='asdf@gmail.com';
  want1=tranwrd(have,'@','-@');
  want2=catx('-@',scan(have,1,'@'),scan(have,2,'@'));
run;

proc print;
run;

Obs         have              want1              want2

 1     asdf@gmail.com    asdf-@gmail.com    asdf-@gmail.com

Re: HOW TO INSERT DELIMITER IN A SRING

ballardw — Fri, 07 May 2021 15:41:34 GMT

One of the things to consider when "inserting" into any string variable is the length of the variable. SAS variables when created will have a defined length. If the current value uses all of the available character positions then "inserting" means that the characters on the end of the value will be truncated because there is no place to store them.

So, your problem description should include:

The length of the variable (find this with Proc Contents if you don't know another way)

Determine the current longest value(s) held in the variable.

See if the resulting inserted value will still fit.

If not, you will need to do something with the length prior.

Here is one way where the length is long enough to hold the inserted character

data example;
   length string $ 50;
   string="asdf@gmail.com";
   string = transtrn(string,'@','_@');
run;

Caution: the Transtrn function will replace all occurrences of the target string, the '@'.

Also, you will not want to run the same code against the same data set repeatedly as you will keep adding _ characters.

Re: HOW TO INSERT DELIMITER IN A SRING

Reeza — Fri, 07 May 2021 15:42:31 GMT

TRANWRD()

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/p0pgemqcslm9uen1tvr5gcrusgrw.htm