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

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

Question No.101

Which one of the following SAS statements renames two variables?

  1. set work.dept1

    work.dept2(rename = (jcode = jobcode) (sal = salary));

  2. set work.dept1

    work.dept2(rename = (jcode = jobcode sal = salary));

  3. set work.dept1

    work.dept2(rename = jcode = jobcode sal = salary);

  4. set work.dept1

work.dept2(rename = (jcode jobcode) (sal salary));

Correct Answer: B

Question No.102

Which one of the following SAS procedures displays the data portion of a SAS data set?

  1. PRINT

  2. FSLIST

  3. CONTENTS

  4. DATASETS

    Correct Answer: A

    Question No.103

    The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses

    2542 100.00

    3612 133.15

    2198 234.34

    2198 111.12

    The following SAS program is submitted: proc sort data = employee_info;

    run;

    Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

    1. by descending IDNumber Expenses;

    2. by (IDNumber Expenses) descending;

    3. by IDNumber descending Expenses descending;

    4. by descending IDNumber descending Expenses;

Correct Answer: D

Question No.104

The following SAS program is submitted: data revenue;

set year_1;

var1 = mdy(1,15,1960); run;

Which one of the following values does the variable named VAR1 contain?

A.

14

B.

15

C.

1151960

D.

#39;1/15/1960#39;

Correct Answer: A

Question No.105

The following SAS program is submitted:

image

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

A.

6

B.

7

C.

8

D.

. (missing numeric)

Correct Answer: B

Question No.106

Given the SAS data set WORK.P2000:

image

And the SAS data set WORK.P2008:

image

The following output is desired:

image

Which SAS program correctly combines the data?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Question No.107

The following SAS program is submitted: libname company #39;SAS-data-library#39;; proc sort data = company.payroll;

by EmployeeIDNumber; run;

Write access has been granted to the COMPANY library.

Which one of the following represents how the observations are sorted?

  1. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.

  2. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.

  3. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.

  4. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber

Correct Answer: A

Question No.108

The following SAS program is submitted: libname sasdata #39;SAS-data-library#39;;

data test;

set sasdata.chemists; if jobcode = #39;chem3#39;

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

run;

A value for the variable JOBCODE is listed below: JOBCODE

CHEM3

Which one of the following values does the variable DESCRIPTION contain?

  1. chem3

  2. Unknown

  3. Senior Chemist

  4. #39; #39; (missing character value)

    Correct Answer: B

    Question No.109

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

    First = #39;Ipswich, England#39;; City = substr(First,1,7);

    City_Country = City!!#39;, #39;!!#39;England#39;;

    run;

    Which one of the following is the value of the variable CITY_COUNTRY in the output data set?

    1. Ipswich!!

    2. Ipswich, England

    3. Ipswich, #39;England#39;

    4. Ipswic h, England

Correct Answer: B

Question No.110

The following SAS program is submitted: data allobs;

set sasdata.origin (firstobs = 75 obs = 499); run;

A.

424

B.

425

C.

499

D.

1000

The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?

Correct Answer: B

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.