05-03-2013 05:33 AM
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.
|TYP/BGS 8X80'S+50% XF|
|WEL W GRP&PEA 12X1L|
|WENS & CRAN 8X180G|
05-03-2013 06:09 AM
Compress() function will delte the required characters
Tranwrd() replaces the words ..
input description $ 32.;
/* new_description1 = compress(description,'%,&'); for deleing only*/
TYP/BGS 8X80'S+50% XF
WEL W GRP&PEA 12X1
WENS & CRAN 8X180G
05-07-2013 06:41 AM
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...