08-16-2013 08:06 AM
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?
08-16-2013 08:24 AM
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%));|
Should achieve your desired results without needing to modify the macro defined by Dr Zhu.
%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