请教sas adv 130题里的3题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

74.The following SAS program is submitted:
%macro one(input);
%two
%put the value is &date;
%mend;
%macro two;
data _null_;
call symput('date', '12SEP2008');
run;
%mend;
%let date = 31DEC2006;
%one(&date)
What is the result when the %PUT statement executes?
A.A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table.
B.A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table.
C.A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro.
D.A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro.

Answer: A, 为什么不选D?

76.
%macro one(input);
%two
%mend;
%macro two;
data _null_;
call symputx('date', '12SEP2008', 'G');
run;
%put the value is &date;
%mend;
%let date = 31DEC2006;
%one(&date)
What is the result when the %PUT statement executes?
A.A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table.
B.A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro.
C.A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro.
D.A macro variable DATE with the value 31DEC2006 is retrieved from the local symbol table for the TWO
macro.

Answer: A

26. Given the SAS data setSASUSER.HIGHWAY:

SASUSER.HIGHWAY

STEERINGSEATBELTSPEED STATUSCOUNT

absentNo0-29serious 31

absentNo0-29not 1419
absentNo30-49serious 191
absentno30-49not 2004
absentno50+serious 216

The following SAS program issubmitted:

%macro highway;

proc sql noprint;
%let numgrp = 6;
select distinct status
into :group1 - :group&numgrp
from sasuser.highway;

quit;

%do i = 1 %to &numgrp;

proc print data =sasuser.highway;
where status ="&&group&i" ;
run;
%end;
%mend;
%highway

How many reports are produced?

A.0

B.2

C.5

D.6

Answer: B, 为什么不选D?

请帮忙解释一下这几道题，多谢！！

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：following statement Variable Statemen proc sql following result null

同求

26. Given the SAS data setSASUSER.HIGHWAY:
absentNo0-29      serious 31
absentNo0-29      not 1419
absentNo30-49    serious 191
absentno30-49    not 2004
absentno50+       serious 216

The following SAS program issubmitted:

%macro highway;
proc sql noprint;
%let numgrp = 6;
select distinct status------>因為dist.的關係, 原始資料裡只有兩種分類(Serious, not), 因此就已經確定只會產生2個group
into :group1 - :group&numgrp
from sasuser.highway;
quit;

%do i = 1 %to &numgrp;
proc print data =sasuser.highway;
where status ="&&group&i" ;--------------->既然只有2個group, 當然Proc print 只會產生2個囉


本文来自: 人大经济论坛 SAS专版 版，详细出处参考： https://bbs.pinggu.org/forum.php? ... e=1&from^^uid=1886358

owl3207 发表于 2013-7-16 11:17
26. Given the SAS data setSASUSER.HIGHWAY:
absentNo0-29      serious 31
absentNo0-29      not 1419 ...

非常感谢高手的解析，再次谢谢！！期待74，76题的解析，呵呵：）

When we use CALL SYMPUT inside a macro definition, it will write the macro variable values into a local symbol table, if the macro has a non empty local symbol table. If macro has an empty local symbol table, the macro variable defined inside a macro, using CALL SYMPUT routine has global scope.

src: http://www.phusewiki.org/docs/2009%20PAPERS/P015.pdf

109238 发表于 2013-7-17 12:04
When we use CALL SYMPUT inside a macro definition, it will write the macro variable values into a lo ...

明白了！谢谢你分享的资料，再次感谢你的解析！！

109238 发表于 2013-7-17 12:04
When we use CALL SYMPUT inside a macro definition, it will write the macro variable values into a lo ...

这么tricky的设置？
当时怎么想的
没道理啊

My Question is:
When it says "the local table is not empty", does it mean that the existing macro variable in the local table doesn't have to to be the macro variable in CALL SYMPUT?

kevinye123 发表于 2013-7-20 18:44
My Question is:
When it says "the local table is not empty", does it mean that the existing macro v ...

我觉得应该是这样

多谢多谢