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 |
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
Many ThanKS Allu!
Alice
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
Many Thanks Urvish! I think you are right, I should not replace it!
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.