topic Edit a character variable and replace parts with blanks or nulls in SAS Programming

Edit a character variable and replace parts with blanks or nulls

Gloveman71 — Tue, 01 Jul 2014 14:12:25 GMT

I am trying to do a find and replace in a character variable. See sample below:

Original character variable---> test.test1.test2.test3

Want to edit replace everything starting with the 1st"." and replace with spaces or nulls, so the final variable contains: test

Any suggestions??

Thanx,

Jim Glover

ballardw — Tue, 01 Jul 2014 14:14:50 GMT

string = scan(string,1,'.');

you don't mention a variable name so i use string as a generic.

yeshwanth — Tue, 01 Jul 2014 14:33:59 GMT

In case if you want to replace all the dots(.) then use this :

name_all=tranwrd(name,'.',' ');

Hope this helps !!