topic Re: Please Help, how to replace character like% and & ? Many Thanks in SAS Programming

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

Question — Fri, 03 May 2013 09:33:44 GMT

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

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

allurai0412 — Fri, 03 May 2013 10:09:52 GMT

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

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

Question — Fri, 03 May 2013 10:13:21 GMT

Many ThanKS Allu!

Alice

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

UrvishShah — Tue, 07 May 2013 10:41:33 GMT

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

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

Question — Tue, 07 May 2013 14:35:58 GMT

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