SAS advance exam question 7: Macro Variables

shiyiming

I am very confused about this Macro Variables question.


The following SAS program is submitted:

  %macro COLS1;
     Name Age;
  %mend;      

  %macro COLS2;
     Height Weight;     
  %mend;      

  proc print data=SASHELP.CLASS;
     [_insert_VAR_statement_here_]      
  run;


  Which VAR statement successfully completes  the program to produce a report containing  four variables?


     A. var %COLS1 %COLS2;     

     B. var %COLS1-%COLS2;     

     C. var %COLS1 Weight Height;      

     D. var Weight Height %COLS1;

I ran these SAS codes and found that D is correct. I am confused why C is not correct. It would be great if anyone would like to explain it a little bit.

^_^

shiyiming

After running the codes,

proc print data=SASHELP.CLASS;
var %COLS1 Weight Height;
run;

I found the error message from the log window.


13   proc print data=SASHELP.CLASS;
14   var %COLS1 Weight Height;
                ------
                180
ERROR 180-322: Statement is not valid or it is used out of proper order.
15   run;


Does it means that Macro can only after the variables in this case?

Thanks in advance.

shiyiming

是分号的问题,不加分号ACD都对
[code:3c6qqso9]%macro COLS1;
   Name Age
%mend;
%macro COLS2;
   Height Weight
%mend;[/code:3c6qqso9]

shiyiming

Yeah, it is the point that confused me. I ran the codes again, and found all options worked well just as your mentioned. Thanks millios!

^_^

shiyiming

算日子你也该考完ADV了呀,还没去哪

shiyiming

I will take the ADV exam on this Friday morning.

shiyiming

这上题目我在考ADV的时候遇到过，当时是猜的。哎。。。。
经教师一指点，原来如此！