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 ...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.