Question

• 如何将宏观变量作为《联合国系统会计准则》中的一种特征

我的目标是把“一”作为瓦尔3的唯一价值,但现在就开始。

“一栏不详”

 %macro test(notvar=)

proc sql;
      connect to odbc as conn (datasrc=x user=&user1. password=&pwd1.);
      create table &notvar. (compress=no) as select * from connection to conn
      (
            select var1, var2,
            &notvar. as var3
            from table1
      );
disconnect from conn;
quit;

%mend test;

%test(notvar=one);

Answer 1

后经测试。我认为,你可将宏观变量作为一栏的价值:

 select var1, var2,
 "&notvar" as var3
 from table1

或

 select var1, var2,
 symget( notvar ) as var3
 from table1

If no quotation mark 或 function f或 fetching macro variable value is specified, the selected object ("one" here in your case) is regarded as a column in the 或iginal table. So you get err或 f或 there is no such column.

友情链接