DATA Step, Macro, Functions and more

How to recover from a bad macro execution

Reply
N/A
Posts: 1

How to recover from a bad macro execution

%macro test;

  %local test;

  %let test=%bquote(proc print;runSmiley Wink;   %*wrong,should use %str instead%*;

  %put &test;

%mend;

%test;

The above macro is wrong, so,after execution, the following DATA doesn't work.

data test;

  length weding $50.;

   weding="Li and Hong's weding";  output;

   weding="Hong and Hong's weding"; output;

   weding="Hong's weding";  output;

   call symput('vfromdata',trim(weding));

run;

but even I follow the macro trouble shooting:http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a001302436.htm

submit the:

   *'; *"; *); */; %mend; run;

and correct the macro %test above (use %str instead). then the macro works fine, but the Data step above still doesn't work。I have to restart SAS, then the data Step works fine again.

any way to avoid restarting SAS to make the Data step work after submit the wrong macro above?

thanks

Contributor
Posts: 44

Re: How to recover from a bad macro execution

I don't think there's anything wrong with your macro (if you use %str).

The dataset, however has single quotes within double-quotes. Rewrite as the following and you should be ok, putting two single quotes together:

data test;

  length weding $50.;

   weding="Li and Hong''s weding";  output;

   weding="Hong and Hong''s weding"; output;

   weding="Hong''s weding";  output;

   call symput('vfromdata',trim(weding));

run;

Respected Advisor
Posts: 3,124

Re: How to recover from a bad macro execution

Well, if that doesn't work, there was a SAS-L discussion talking about 'enhanced magic strings':

http://www.listserv.uga.edu/cgi-bin/wa?A2=ind9810b&L=sas-l&P=17321

Good Luck,

Haikuo

Ask a Question
Discussion stats
  • 2 replies
  • 211 views
  • 0 likes
  • 3 in conversation