BookmarkSubscribeRSS Feed
EzPaste
Calcite | Level 5

hello,

There are instances where I need to modify some html code in the the files produced by ods html, through sas

I have found a nice macro Home Page of Dr. Songlin Zhu  but I experience some difficulties using it with strings that contain quotes/double quotes, particularly unbalanced ones

Is it possible to adapt it to fit these cases?

Thanks

Abe

1 REPLY 1
Vince28_Statcan
Quartz | Level 8

Could you provide a more specific example that fails? Just copy like one line with at least one occurence of what you are attempting to replace. At first glance, it looks like %str or %nrstr paired with appropriate use of the following examples that can be found in %nrstr documentation

Notation Description Example Quoted Value Stored
%' unmatched single quotation mark %let myvar=%str(a%'); a'
%" unmatched double quotation mark %let myvar=%str(title %"first); title "first
%(unmatched open parenthesis%let myvar=%str (log%(12); log(12
%)unmatched close parenthesis%let myvar=%str (345%));

345)

Should achieve your desired results without needing to modify the macro defined by Dr Zhu.

Something like

%let old_str=%str(Mike said:%"Hey);

%let new_str=%str(Mike whispered:%"Halt);

Should appropriately prevent the unbalanced quote error when dereferencing old_str/new_str in the macro

Vincent

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1475 views
  • 3 likes
  • 2 in conversation