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

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

Question No.61

The following SAS program is submitted: data test;

set sasuser.employees;

if 2 le years_service le 10 then amount = 1000;

else amount = 0;

amount_per_year = years_service / amount run;

What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?

A.

0

B.

0.001

C.

1

D.

. (missing numeric value)

Correct Answer: D

Question No.62

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

set work.dept1 work.dept2; jobcode = `FA1#39;;

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 Answer: B

Question No.63

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

image

Which statement is true?

  1. The by statement in the DATA step causes a syntax error.

  2. The statement Payroll (MonthlyWageRate*12); in the data step causes a syntax error.

  3. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

  4. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

Correct Answer: C

Question No.64

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

set work.salary(keep = department wagerate); by department;

if first.department then payroll = 0; payroll wagerate; if last.department

run;

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

What is the result?

  1. The WORK.TOTAL data set contains 5 observations.

  2. The WORKTDTAL data set contains 100 observations.

  3. The WORKTOTAL data set contains 500 observations.

  4. The program fails to execute due to errors.

Correct Answer: A

Question No.65

The following SAS program is submitted: data WORK.ACCOUNTING;

set WORK.DEPARTMENT;

label Jobcode=#39;Job Description#39;; run;

Which statement is true about the output dataset?

  1. The label of the variable Jobcode is Job (only the first word).

  2. The label of the variable Jobcode is Job Desc (only the first 8 characters).

  3. The label of the variable Jobcode is Job Description.

  4. The program fails to execute due to errors. Labels must be defined in a PROC step.

Correct Answer: C

Question No.66

The contents of the raw data file PRODUCT are listed below:

-10-20-30

24613 $25.31

The following SAS program is submitted: data inventory;

infile #39;product#39;;

input idnum 5. @10 price; run;

Which one of the following is the value of the PRICE variable? A. 25.31

B. $25.31

  1. . (missing numeric value)

  2. No value is stored as the program fails to execute due to errors.

Correct Answer: C

Question No.67

Given the SAS data set EMPLOYEES: EMPLOYEES

NAME SALARY

Innis60000 Jolli50000 Ellis55000 Liu45000

The following SAS program is submitted:

proc print data = employees; where name like `_i%#39;; run;

What is contained in the output?

  1. Liu only

  2. Innis and Ellis only

  3. Innis, Ellis, and Liu only

  4. Innis, Jolli, Ellis, and Liu

Correct Answer: A

Question No.68

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

  1. infile #39;customer.txt#39; 1-10;

  2. input #39;customer.txt#39; stop@10;

  3. infile #39;customer.txt#39; obs=10;

  4. input #39;customer.txt#39; stop=10;

Correct Answer: C

Question No.69

The following SAS program is submitted:

image

What new variables are created?

  1. Difcount1, Difcount2 and Difcount3

  2. Diff1, Diff2 and Diff3

  3. Janpt, Febpt, and Marpt

  4. Patients1, Patients2 and Patients3

Correct Answer: A

Question No.70

Given the contents of the raw data file EMPLOYEE:

-|10|20|30

Alan 19/2/2004 ACCT

Rob 22/5/2004 MKTG

MaryJane 14/3/2004 EDUC

The following SAS program is submitted: data emps;

infile `employee#39;; input@1 name$

@15 date lt;insert INFORMAT heregt;

@25 department$; run;

Which INFORMAT correctly completes the program?

  1. date9.

  2. ddmmyyyy9.

  3. ddmmyy10.

  4. ddmmyyyy10.

Correct Answer: C

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Proudly powered by WordPress