[Free] 2019(Nov) EnsurePass SAS Institute A00-201 Dumps with VCE and PDF 11-20

Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html

Question No.11

Given the SAS data set PERM.STUDENTS: PERM.STUDENTS NAMEAGE

Alfred14 Alice13 Barbara13 Carol14

The following SAS program is submitted: libname perm `SAS data library#39;;

data students;

set perm.students; file `file specification#39;; put name $ age;

lt;insert statement heregt; run;

The following double-spaced file is desired as output

Alfred 14

Alice 13

Barbara 13

Carol 14

Which statement completes the program and creates the desired file?

  1. put

  2. put/;

  3. double;

  4. put _null_;

Correct Answer: A

Question No.12

The following SAS program is submitted: data work.empsalary;

set work.people (in = inemp) work.money (in = insal);

if insal and inemp; run;

The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?

A.

0

B.

5

C.

7

D.

12

Correct Answer: A

Question No.13

The following SAS program is submitted: data work.new;

length word $7; amount = 4;

it amount = 4 then word = `FOUR#39;; else if amount = 7

then word = `SEVEN#39;;

else word = `NONE!!!#39;; amount = 7;

run;

What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

  1. amount word 4 FOUR

  2. amount word 4 NONE!!!

  3. amount word 7 FOUR

  4. amount word 7 SEVEN

Correct Answer: C

Question No.14

Which statement correctly computes the average of four numerical values?

  1. average = mean(num1, num4);

  2. average = mean(num1 – num4);

  3. average = mean(ofnum1 – num4)

  4. average = mean(num1 num2 num3 num4);

Correct Answer: C

Question No.15

The following SAS program is submitted: data test;

set chemists; jobcode = `Chem2#39;

then description = `Senior Chemist#39;; else description = `Unknown#39;;

run;

The value for the variable JOBCODE is: JOBCODE

chem2

What is the value of the variable DESCRIPTION?

  1. chem2

  2. Unknown

  3. Senior Chemist

  4. ` ` (missing character value)

Correct Answer: B

Question No.16

Given the raw data record in the file phone.txt:

image

Which SAS statement completes the program and results in a value of quot;James Stevensquot; for the variableFullName?

  1. FullName=CATX(#39; #39;,EmpFName,EmpLName);

  2. FullName=CAT(#39; #39;,EmpFName,EmpLName);

  3. FullName=EmpFName!!EmpLName;

  4. FullName=EmpFName EmpLName;

Correct Answer: A

Question No.17

Which ODS statement option terminates output being written to an HTML rile?

  1. END

  2. QUIT

  3. STOP

  4. CLOSE

Correct Answer: D

Question No.18

The following SAS program is submitted: data test;

infile `file specification#39;; input name $ amount@@; run;

Which of the following is true?

  1. Two @@ together are the same as one c.

  2. Two @@ hold the data records until the bottom of the DATA step.

  3. Two @@ hold the raw data record across iterations of the DATA step.

  4. Two @@ are invalid syntax and will cause the program to fail to execute.

Correct Answer: C

Question No.19

The following output is created by the FREQUENCY procedure:

image

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

  1. norowcount nocolcount

  2. freq percent

  3. norow nocol

  4. nocounts

    Correct Answer: C

    Question No.20

    The following SAS program is submitted:

    image

    How many observations are written to the WORK.SALES data set?

    A.

    0

    B.

    1

    C.

    5

    D.

    60

    Correct Answer: B

    Get Full Version of the Exam
    A00-201 Dumps
    A00-201 VCE and PDF