sas base 程序-经管之家官网！

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

45.The following SAS program is submitted:

ods csvall file='c:\test.cvs';

proc print data=WORK.ONE;

var Name Score Grade;

by IdNumber;

run;

ods csvall close;

What is produced as output?

A. A file named test.cvs that can only be opened in Excel.

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

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

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

Answer: C cvs是什么格式？

另外，

norow nocol是什么意思呢？

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 Alpha Ave. NY

Jennifer Jason 666 Mt. Diablo

B.

Name Address City State

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

Joe Conley 123 Main St. Janesville

Jane Ngyuen 555 Alpha Ave. New York NY

Jennifer Jason 666 Mt. Diablo Eureka

C.

Name Address State

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

Jane Ngyuen 555 Alpha Ave. NY

D. O observations,there is a syntax error in the data step.

Answer: A

这道题不是很懂，drop 语句在最前面，后面的city变量有意义吗？else input的含义又是什么呢？

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