BookmarkSubscribeRSS Feed
dreamcatcher
Calcite | Level 5

%macro test;

  %local test;

  %let test=%bquote(proc print;run;);   %*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

2 REPLIES 2
JasonDiVirgilio
Quartz | Level 8

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;

Haikuo
Onyx | Level 15

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 767 views
  • 0 likes
  • 3 in conversation