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

November 5, 2019

A00-201 Dumps 2019-11

, , , , , ,

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

Question No.181

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

date = put(#39;13mar2000#39;d,ddmmyy10.); run;

Which one of the following represents the type and length of the variable DATE in the output data set?

  1. numeric, 8 bytes

  2. numeric, 10 bytes

  3. character, 8 bytes

  4. character, 10 bytes

Correct Answer: D

Question No.182

The following SAS program is submitted:

image

Which statement is true about the output data set?

  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. Labels can only be defined in PROC steps. The program fails to execute due to errors and the data set is not created.

Correct Answer: C

Question No.183

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

cost = #39;20000#39;; total = .10 * cost; run;

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

A. 2000

B. #39;2000#39;

  1. . (missing numeric value)

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

Correct Answer: A

Question No.184

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

set work.allmonths (keep = product month num_sold cost); if month = #39;Jan#39; then output work.january;

sales = cost * num_sold; keep = product sales; run;

Which variables does the WORK.JANUARY data set contain?

  1. PRODUCT and SALES only

  2. PRODUCT, MONTH, NUM_SOLD and COST only

  3. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

  4. An incomplete output data set is created due to syntax errors.

Correct Answer: D

Question No.185

The following SAS program is submitted:

data work.totalsales (keep = monthsales{12} );

set work.monthlysales (keep = year product sales); array monthsales {12} ;

do i=1 to 12; monthsales{i} = sales; end;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

Which one of the following is the result of the above program?

  1. The program fails execution due to data errors.

  2. The program fails execution due to syntax errors.

  3. The program executes with warnings and creates the WORK.TOTALSALES data set.

  4. The program executes without errors or warnings and creates the WORK.TOTALSALES data set

    Correct Answer: B

    Question No.186

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

    set work.sales_info;

    if qtr(sales_date) ge 3; run;

    The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.

    How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set?

    A.

    2

    B.

    3

    C.

    6

    D.

    9

    Correct Answer: C

    Question No.187

    The following SAS program is submitted:

    image

    What is produced as output?

    1. A file named test.cvs that can only be opened in Excel.

    2. A text file named test.cvs that can be opened in Excel or in any text editor.

    3. A text file named test.cvs that can only be opened in a text editor.

    4. A file named test.cvs that can only be opened by SAS.

Correct Answer: B

Question No.188

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

data work.new; set temp.jobs;

format newdate mmddyy10.; qdate = qtr(newdate);

ddate = weekday(newdate); run;

proc print data = work.new; run;

The variable NEWDATE contains the SAS date value for April 15, 2000. What output is produced if April 15, 2000 falls on a Saturday?

  1. Obs newdate qdate ddate 1 APR152000 2 6

  2. Obs newdate qdate ddate 1 04/15/2000 2 6

  3. Obs newdate qdate ddate 1 APR152000 2 7

  4. Obs newdate qdate ddate 1 04/15/2000 2 7

Correct Answer: D

Question No.189

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

-10-20-30

chair,,table chair,couch,table

The following SAS program is submitted: data stock;

infile #39;furniture#39; dsd;

input item1 $ item2 $ item3 $; run;

Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

  1. table

  2. ,table

  3. . (missing numeric value)

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

Correct Answer: D

Question No.190

The following SAS program is submitted: options pageno = 1;

proc print data = sasuser.houses; run;

proc means data = sasuser.shoes; run;

The report created by the PRINT procedure step generates 5 pages of output.

What is the page number on the first page of the report generated by the MEANS procedure step?

A.

1

B.

2

C.

5

D.

6

Correct Answer: D

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

Related Posts