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

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

Question No.81

Given the SAS data set EMPLOYEE INFO: EMPLOYEE_INFO

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;

lt;insert BY statement heregt; run;

Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

  1. by Expenses IDNumber;

  2. by IDNumber Expenses;

  3. by ascending Expenses IDNumber;

  4. by ascending IDNumber ascending Expenses;

Correct Answer: B

Question No.82

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

  1. format salary comma11.2;

  2. format salary dollar8.2;

  3. format salary dollar11.2;

  4. format salary comma8.2 dollar8.2;

Correct Answer: C

Question No.83

Which is a valid LIBNAME statement?

  1. libname quot;_SAS_data_library_location_quot;;

  2. sasdata libname quot;_SAS_data_library_location_quot;;

  3. libname sasdata quot;_SAS_data_library_location_quot;;

  4. libname sasdata sas quot;_SAS_data_library_location_quot;;

Correct Answer: C

Question No.84

The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.;

The following SAS program is submitted: data history;

format local fee country fee percent6.; set realestate;

local fee = local fee / 100; country fee = country fee / 100; run;

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

  1. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.

  2. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.

  3. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.

  4. The data step fails execution; there is no format for LOCALFEE

Correct Answer: C

Question No.85

Given the following raw data record:

-I10-I20-I 30

son Travis,

The following output is desired: Obs relation firstname

1 son Travis

Which SAS program correctly reads in the raw data?

  1. data family ( dIm = `,#39;); infile `tile specification#39;; input relation $ firstname $; run;

  2. options dIm = `,#39;; data family; infile `file specification#39;; input relation $ firstname $; run;

  3. data family; infile `file specification#39; dIm = `,#39;; input relation $ firstname $; run;

  4. data family; infile `file specification#39;; input relation $ firstname $ / dim = `,#39;; run;

Correct Answer: C

Question No.86

Given the contents of the raw data file TYPECOLOR.DAT:

image

The following SAS program is submitted:

image

What are the values of the variables Type and Color?

  1. Type=daisy, Color=yellow

  2. Type=daisy, Color=w

  3. Type=daisy, Color=daisyyellow

  4. Type=daisy, Color=

Correct Answer: D

Question No.87

The following SAS program is submitted:

image

What types of variables are DayOfMonth, MonthOfYear, and Year?

  1. DayOfMonth, Year, and MonthOfYear are character.

  2. DayOfMonth, Year, and MonthOfYear are numeric.

  3. DayOfMonth and Year are numeric. MonthOfYear is character.

  4. DayOfMonth, Year, and MonthOfYear are date values.

Correct Answer: B

Question No.88

A user-defined format has been created using the FORMAT procedure. Where is it stored?

  1. in a SAS catalog

  2. in an external binary file

  3. in a SAS dataset in the WORK library

  4. in a SAS dataset in a permanent SAS data library

Correct Answer: A

Question No.89

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

data temp.sales; merge temp.sales work.receipt;

by names; run;

The input data files are sorted by the NAMES variable: What is the result?

  1. The program executes successfully and a temporary SAS data set is created.

  2. The program executes successfully and a permanent SAS data set is created.

  3. The program fails execution because the same SAS data set is referenced for both read and write operations.

  4. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

Correct Answer: B

Question No.90

Given the SAS data set SASDATA TWO: SASDATA TWO

XY

– 52

31

56

The following SAS program is submitted: data sasuser.one two sasdata.three;

set sasdata two;

if x = 5 then output sasuser.one; else output sasdata two;

run;

What is the result?

  1. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations

  2. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations

  3. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations

  4. No data sets are output.

    The DATA step fails execution due to syntax errors.

    Correct Answer: A

    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