topic Re: How to create a macro variable equal to %vs% in SAS Programming

How to create a macro variable equal to %vs%

Macro — Mon, 27 Oct 2014 20:49:40 GMT

I use following to create a macro variable pattern so that it equals to %vs%:

%let pattern=%nrstr(%vs%);

%put pattern =&pattern;

But SAS gives error and warning:

WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks.

How to achieve the desired result?

Re: How to create a macro variable equal to %vs%

FriedEgg — Mon, 27 Oct 2014 21:12:37 GMT

%let pattern=%nrstr(%%vs%%);

%put pattern=&pattern.;

pattern=%vs%

Re: How to create a macro variable equal to %vs%

Macro — Mon, 27 Oct 2014 21:38:08 GMT

Note that %nrstr() will mask % sign, then why do we need doulbe percent sign like %% to achieve a %??

Re: How to create a macro variable equal to %vs%

Macro — Mon, 27 Oct 2014 21:40:03 GMT

Also why do we need a dot after &pattern?

Re: How to create a macro variable equal to %vs%

FriedEgg — Mon, 27 Oct 2014 21:48:13 GMT

You do not "need" it. You could just consider it my personal preference for coding style.

Re: How to create a macro variable equal to %vs%

FriedEgg — Mon, 27 Oct 2014 22:01:50 GMT

The real issue is the second %. The way %nrstr works, as vs% it will assume you are masking the ) sign on %nrstr(%vs%) and thus leave you with open code.

You could do any of the following:

%let pattern=%nrstr(%vs% );

%let pattern=%nrstr(%vs%%);

%let pattern=%nrstr(%%vs%%);

I prefer the last one...

Re: How to create a macro variable equal to %vs%

Macro — Mon, 27 Oct 2014 22:08:44 GMT

Thanks very much, very good explanation.