This is not code that SAS is complaining about, it is the data in a variable.
No, it isn't. It is your coding. Fix it.
You don't have to send us data but you can always change variable names and comments before you post log to the open space.
BTW: SAS 9.1.3 is an over 10 years old version on support level C so it would be really time to upgrade.
This "NOTE" also causes my SAS stored process to claim "Stored Process Error" "This request completed with errors.".
Fixing the problem causes the NOTE and the error condition to go away.
The fix in my case is to use %bquote.
I have html in variables in a SAS dataset which gets loaded into a macro variable using symputx. The double quotes in the html are double double quoted because I am going to have to resolve them inside double quotes.
The ultra-simplified example is:
data _null_;
length html $80;
** html is read from another dataset **;
html = '<table border=""0"" class=""table1"">';
call symputx("html",html);
run;
%let html1 = %scan(&html.,1,>)>; * A macro code operation on html;
data work.test;
put "&html1.";
run;
Fix is:
%let html1 = %bquote(%scan(&html.,1,>)>);
but I don't see why the note is warranted in any case and it certainly should not put the code into error condition.
@marq wrote:
This "NOTE" also causes my SAS stored process to claim "Stored Process Error" "This request completed with errors.".
Fixing the problem causes the NOTE and the error condition to go away.
The fix in my case is to use %bquote.
I have html in variables in a SAS dataset which gets loaded into a macro variable using symputx. The double quotes in the html are double double quoted because I am going to have to resolve them inside double quotes.
The ultra-simplified example is:
data _null_;
length html $80;
** html is read from another dataset **;
html = '<table border=""0"" class=""table1"">';
call symputx("html",html);
run;
%let html1 = %scan(&html.,1,>)>; * A macro code operation on html;
data work.test;
put "&html1.";
run;
Fix is:
%let html1 = %bquote(%scan(&html.,1,>)>);
but I don't see why the note is warranted in any case and it certainly should not put the code into error condition.
Thanks Marq - this was exactly the problem I was having and %bquote fixed my issue as well.
@RobP, @ShelleySessoms, @Kurt_Bremser, @Reeza, @ballardw -
Calling all if even semi-gurus to figure out this one could have been marked as solved.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.