Hi all,
I have this macro SAS:
%macro aggiorna(id=); proc sql; select distinct id,LOCATION_DESCRIPTION1 into :id ,:location_description1 from lo1 where id=&id.; quit; %put valore id ------>&id.; %put valore location_description ------>&location_description1.;
proc sql; UPDATE a2.inspection SET location_description =%unquote("&LOCATION_DESCRIPTION1.") WHERE ID = &id.; quit; %mend;
proc sql; create table LOCATION as select distinct id from lo1 ; quit; data _null_; set LOCATION(OBS=1); call execute('%nrstr(%aggiorna(id='!!id!!'));'); run;
I must update the column in the dataset with the value that I have in my dataset, but che macrovariable &location_description1. contains value with apostrophe and I receive this error:
ERROR: Literal contains unmatched quote.
For example, value macro &location_description1:
PANTANO D'AVIO'
and I don't find a solution.
How is possibile resolve my error?
I try use different function for example %nrquote or %bquote but I don't resolve.
Thank you for your response.
... View more