Geek asks and answers

Unrivaled SAS quotation mark

As everyone knows, SAS needs special care about quotes inside a sentence.

eg.

%let quoted="I'd like to";
data temp;
    set temp;
    quoted="&quoted";
run;

an error occurs when sending.

Actually, I need to copy the data into one data set from another, in which there are many records containing quotes. Upon assignment, occurrence of an error, and completion of the step-by-step data entry operation, as a result of which the rest of the code becomes invalid. Thus, in this case, it is impossible to change the original data set by adding duplicated quotes, which does not make sense.

So, instead of adding duplicate text such as “I wanted”, is there any other way to avoid the error or make the execution of the data complete?

Thank,

+3
source share
2

( % let) . , , % str(). % let . % escape-, SAS, ( ). , % let, .

%let quoted=%str(I%'d like to);
data temp;    
    quoted="&quoted";
run;

Rob

+5

, , .

%let quoted="I'd like to";
data temp;
    set temp;
    quoted=&quoted;
run;
+2

More articles:


All Articles