[share_ebook] SAS a00-211 Exam Demo

作者: pennychen2009

Free Download Babylon Translate Software

The poster (email) is not available. 收藏推荐:

图书介绍

Author: pennychen2009

Exam Number/Code: A00-212
Exam Name: SAS Advanced Programming Exam for SAS 9

"SAS Advanced Programming Exam for SAS 9", also known as A00-212 exam, is a SAS Institute certification.

1.Given the SAS data set AGES:

AGES
AGE
-------
9
12
15

The variable AGE contains character values.

The following SAS program is submitted:

data subset;
set ages;
where age > 12; A00-212
run;

How many observations are written out to the data set SUBSET?

A: 0
B: 1
C: 2
D: 3
Correct Answers: A

2.The following SAS program is submitted:

data temp.x;
set sasuser.y;
run;

What must be submitted prior to this SAS program for the program to execute successfully?

A: A LIBNAME statement for the libref TEMP only must be submitted.
B: A LIBNAME statement for the libref SASUSER only must be submitted.
C: LIBNAME statements for the librefs TEMP and SASUSER must be submitted. 310-200
D: No LIBNAME statement needs to be submitted.
Correct Answers: A

3.Given the SAS data set ONE:

ONE
Obs Dte
------ -----
1 09JAN2005
2 12JAN2005

The following SAS program is submitted:

data two;
set one;
day = <insert expression here>; 70-503(VB)
format dte date9.;
run;

The data set TWO is created:

TWO
Obs Dte Day
----- ---- -----
1 09JAN2005 1
2 12JAN2005 4

Which expression successfully completed the program and created the variable DAY?

A: day(dte)
B: weekday(dte)
C: dayofweek(dte)
D: datdif(dte,'01jan2005'd,'act/act')
Correct Answers: B

4.Given the SAS data sets EMPLOYEE and SALARY:

EMPLOYEE SALARY
Fname age name salary
--------- ----- -------- --------
Bruce 30 Bruce 25000 HP0-X02
Dan 40 Bruce 35000
Dan 25000

The following SAS program is submitted:

data work.empdata;
<insert MERGE statement here>
by fname;
totsal + salary;
run;

Which MERGE statement correctly completes the program?

A: merge employee
salary rename = fname = name;
B: merge employee
salary rename(name = fname);
C: merge employee
salary (rename = (fname = name));
D: merge employee
salary (rename = (name = fname)); EX0-103
Correct Answers: D

5.The following SAS program is submitted:

data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;

What is the value of the variable PROD in the output data set?

A: 6
B: 7
C: 8
D: . (missing numeric)
Correct Answers: B

6.Given the SAS data set PRICES: ee0-411

PRICES
prodid price producttype sales returns
-------- ------ ---------------- -------- ---------
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

data hware inter cheap;
set prices(keep = producttype price);
if producttype = 'HARDWARE' then output hware;
else if producttype = 'NETWORK' then output inter;
if price le 5.00; JN0-342
run;

How many observations does the HWARE data set contain?

A: 0
B: 2
C: 3
D: 4
Correct Answers: D

7.Given the SAS data set PRICES:

PRICES
prodid price producttype sales returns
---------- ------ -------------- ------ ----------
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER; HT0-201
else if producttype = 'SOFTWARE' then output SOFT;
run;

How many observations does the HWARE data set contain?

A: 0
B: 2
C: 3
D: 4
Correct Answers: B

8.The following SAS program is submitted:

data test;
infile 'file specification';
input name $ amount @@;
run;

Which of the following is true?

A: Two @@ together are the same as one @.
B: Two @@ hold the data records until the bottom of the DATA step.
C: Two @@ hold the raw data record across iterations of the DATA step.
D: Two @@ are invalid syntax and will cause the program to fail to execute.ec0-479
Correct Answers: C

9.The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?

A: format salary comma11.2;
B: format salary dollar8.2;
C: format salary dollar11.2;
D: format salary comma8.2 dollar8.2;
Correct Answers: C

10.The following SAS program is submitted:

data work.accounting;
set work.dept1 work.dept2; 922-089
jobcode = 'FA1';
length jobcode $ 8;
run;

A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets.

The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.

What is the length of the variable JOBCODE in the output data set?

A: 3
B: 5
C: 7
D: 8
Correct Answers: B

More Information:70-541(VB) 70-634 642-586 70-284 n10-003

[Translate] Download Babylon Translate Software for Free!
[Directly Download] [share_ebook] SAS a00-211 Exam Demo!

Download this book from Usenet

Free register and download UseNet downloader, then you can free download from UseNet.

Download " SAS a00-211 Exam Demo" from Usenet!

使用Usenet下载

免费注册即可使用Usenext下载电子书！
Usenet是来自德国的下载软件，强大的共享网络搜索下载工具，免费注册后即可不限速下载150G 电子书，Audiobook等等~~赶快下载使用吧！

Copyright Disclaimer:
本站一切内容源于互联网搜索，禁止商用！如有任何不妥请联系:admin@ebookee.com，我们将在24小时内删除相关内容。

浏览量：457 添加时间：2008-06-06 16:17:48, 更新时间：2008-06-06 16:17:48, shared by pennychen2009

搜索该书!...

Search mirrors of "[share_ebook] SAS a00-211 Exam Demo"...

下载链接

Free Magazine Subscriptions & Technical Document Downloads

Comments

"[share_ebook] SAS a00-211 Exam Demo" 没有评论.

如果没有下载链接或者下载链接无效，请查看相关链接或者搜索相关资料。

[share_ebook] SAS a00-211 Exam Demo

作者: pennychen2009

图书介绍

搜索该书!...

下载链接

相关链接

Comments

Leave a Comment