Please Help, how to replace character like% and & ? Many Thanks

[Question]

Hi All,

I have a list of items purchased, and they have characters like & or % , but I would like to replace them by Perc or And For example...It's because I am running a macro and I am getting the following warning. Your help would be much appreciated. Many Thanks

WARNING: Apparent invocation of macro XF not resolved.

WARNING: Apparent symbolic reference PEA12X1L not resolved.

WARNING: Apparent symbolic reference CRAN8X180G not resolved.

DESCRIPTION

TYP/BGS 8X80'S+50% XF

WEL W GRP&PEA 12X1L

WENS & CRAN 8X180G

[allurai0412]

hi ,

Compress() function will delte the required characters

Tranwrd() replaces the words ..

please try.....

data want;
   input description $ 32.;

  /* new_description1 = compress(description,'%,&'); for deleing only*/
  description=tranwrd(description,'%','Percentage');
  description=tranwrd(description,'&','And');
   datalines;
   TYP/BGS 8X80'S+50% XF
   WEL W GRP&PEA 12X1
   WENS & CRAN 8X180G
   ;
   run;

Regards

Allu

[Question]

Many ThanKS Allu!

Alice

[UrvishShah]

If you want to replace "&" and "%" with Per and AND only because you get the warning message by invoking your macro then i think rather than replacing them you can use Macro Quoting Function to mask the Macro Language Elements if it is set to your business requirement...

%let DESCRIPTION = %nrstr(TYP/BGS 8X80'S+50% XF);

It will intrepreate as text rather than Macro language elements...

-Urvish

[Question]

Many Thanks Urvish! I think you are right, I should not replace it!