topic Re: Quote substring in marco in SAS Programming

Quote substring in marco

sas_newbie3 — Tue, 21 Feb 2017 17:13:22 GMT

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

What is the correct answer? A or B?

collinelliot — Tue, 21 Feb 2017 17:28:26 GMT

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 — Tue, 21 Feb 2017 17:28:38 GMT

Check it yourself:

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

%put &X;

Daniel Santos @ www.cgd.pt