Hi i am trying remove spl char at a time . but it's not work proparly .
exp;
data exp;
a='i will try to removie spl char @ and another spl $';
a1=tranwrd(a,'@$' , '' );
run;
i want a1 varibel with out spl char;
To REMOVE characters use COMPRESS funtion. TRANWRD is the wrong funtion for your problem.
To REMOVE characters use COMPRESS funtion. TRANWRD is the wrong funtion for your problem.
Or translate may be what you were thinking of.
data exp; a='i will try to removie spl char @ and another spl $'; a1=translate (a,'','@$' ); run;
@ballardw wrote:
Or translate may be what you were thinking of.
data exp; a='i will try to removie spl char @ and another spl $'; a1=translate (a,'','@$' ); run;
Translate doesn't remove the characters you are replacing with blanks.
Understood @data_null__ but since the OP started with one of the translate functions I was hoping to point him to the slightly more correct option.
And since there was not actual desired output posted ...
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.