DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 96

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

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
Frequent Contributor
Posts: 97

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

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

Frequent Contributor
Posts: 96

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

Many ThanKS Allu!

Alice

Regular Contributor
Posts: 195

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

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

Frequent Contributor
Posts: 96

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

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

Ask a Question
Discussion stats
  • 4 replies
  • 272 views
  • 0 likes
  • 3 in conversation