About indirect macro variable reference

Jianan_luna — Sat, 22 Aug 2020 00:14:42 GMT

I am currently studying SAS Macro Language 1 essentials course. When I was doing level 2 practice under 3.4 indirect references to macro variables. For question 3, I am confused the answer, "&&&code", why don't use "&&countrycode&code"? Thanks so much. And what does &&&code stand for?

Re: About indirect macro variable reference

Cynthia_sas — Sat, 22 Aug 2020 00:41:29 GMT

Hi:

You did not create numbered variables. That is why you don't have &&country&code.

Please go back and watch the video on macro variable resolution. In particular the forward scan rule and the rescan rule:

After your first DATA _NULL_ step, you can insert a %PUT _USER_ and then in the LOG you'll see that the country 2 character code is the macro variable, as shown below:

So if you want to have the macro variable resolve to Luxembourg for the TITLE, you need to use &LU or some reference that will end up turning into &LU and then Luxembourg. And if you wanted it to appear as United Kingdom, you'd need to use &GB.

But, the WHERE statement needs to use the 2 character code to select the rows you want That's where &code comes in. For the WHERE statement to work, you need to be able to pass in the string "LU" or "IT" or "GB" -- but then, as long as you have that string and you can use that string for a macro variable, then indirect references allows &&&code to turn into &LU and to then resolve to Luxembourg for the title.

Hope that makes sense,

Cynthia

topic About indirect macro variable reference in New SAS User

About indirect macro variable reference

Re: About indirect macro variable reference