Quote substring in marco

[sas_newbie3]

%let x=%substr("ABCD",2,1); 

What is the correct answer? A or B?

[collinelliot · Accepted solution]

A is correct.

In the macro language, the quoting is not necessary, so the opening " is the first character in the string and A is the second.

You could use "%let x=%substr(ABCD,2,1);" and get the result you expect.

[DanielSantos]

Check it yourself:

%let x=%substr("ABCD",2,1); 

%put &X;

Daniel Santos @ www.cgd.pt