3道BASE题目 求高手解惑-经管之家官网！

免费学术公开课,扫码加入

45.The following SAS program is submitted:

ods csvallfile='c:\test.cvs';

proc printdata=WORK.ONE;

var Name ScoreGrade;

by IdNumber;

run;

ods csvall close;

What is produced as output?

A. A file named test.cvs thatcan only be opened in Excel.

B. A text file named test.cvsthat can be opened in Excel or in any text editor.

C. A text filenamed test.cvs that can only be opened in a text editor.

D. A file named test.cvs thatcan only be opened by SAS.

Answer: C

问题： 1.）哪里有详细的ODS destination 的介绍？ 我看的是base prep guide 寥寥数语就带过了。

2.）另外 我敢打包票excel绝对能够打开CVS， 用import wizard 100%能打开！

3.换用excel 能打开的ods, 切text editor 能打开的ODS是什么？

48.The following SAS program is submitted:

data WORK.TEST;

drop City;

infile datalines;

input

Name $ 1-14 /

Address $ 1-14 /

City $ 1-12 ;

if City='New York' then input @1 State $2.;

else input;

datalines;

Joe Conley

123 Main St.

Janesville

WI

Jane Ngyuen

555 Alpha Ave.

New York

NY

Jennifer Jason

666 Mt. Diablo

Eureka

CA;

What will the data set WORK.TEST contain?

A. Name Address State

-------------- ---------------- ------

Joe Conley 123 Main St.

Jane Ngyuen 555 AlphaAve.

NYJennifer Jason 666 Mt. Diablo

B. Name Address City State

-------------- ---------------------------------

Joe Conley 123 Main St. Janesville

Jane Ngyuen 555 AlphaAve. New York NY

Jennifer Jason 666 Mt.Diablo Eureka

C.

Name Address State

-------------- ---------------- ------

Jane Ngyuen 555 AlphaAve. NY

D. O observations,there is asyntax error in the data step. correct Answer:

A这道题为什么不选B？city为什么不输出？？？
还有最末的else input； 到底是什么意思？

53.The following SAS program is submitted:

data WORK.TOTAL_SALARY;

retain Total;

set WORK.SALARY;

by Department;

if First.Department then Total=0;

Total=sum(Total, Wagerate);

if Last.Total;

run; 正确答案说是total 的initial value=missing.但是retain 在没有argument 的情况下， 不应该是 retain either input or assignment 的value, from one data step to next 吗？至少也应该能够从读取的数据库里面保留下来吧
另外retain 没有argument, retain 的variable 没有被created， 那么retain 也应该赋值0给这个variable啊？
所以我选了D， cannot be determined from the information given.
感谢各位老大！
谢谢！

「经管之家」APP：经管人学习、答疑、交友，就上经管之家！
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP