SAS Institute A00-201 dumps - 100% Pass Guarantee!

The following SAS DATA step is submitted:

libname temp `SAS-data-library';

data temp.report;

set sasuser.houses;

newvar = price * 1.04;

run;

Which one of the following statements is true regarding the program above?

A. The program is reading from a temporary data set and writing to a temporary data set.

B. The program is reading from a temporary data set and writing to a permanent data set.

C. The program is reading from a permanent data set and writing to a temporary data set.

D. The program is reading from a permanent data set and writing to a permanent data set.

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

----|----10----|----20----|----30

The following SAS program is submitted:

data test;

infile `calendar';

input@1 date mmddyy10.;

if date = `01012000'd then event = `January 1st;

run;

Which one of the following is the value of the EVENT variable?

A. 01012000

B. January 1st

C. .(missing numeric value)

D. The value can not be determined as the program fails to execute due to errors.

A raw data file is listed below:

----I---- 10---I----20---I----30

squash 1.10 apples 2.25 juice 1.69

The following SAS program is submitted using the raw data file above:

data groceries; infile `file-specification'; input item $ cost; run;

Which one of the following completes the program and produces a grand total for all COST values?

A. grandtot = sum cost;

B. grandtot = sum(grandtot,cost);

C. retain grandtot 0; grandtot = sum(grandtot,cost);

D. grandtot = sum(grandtot,cost); output grandtot;

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

data work.passengers;

if OrigPassengers = then

OrigPassengers = 100;

TransPassengers = 100;

OrigPassengers = .;

NonPaying = 10;

TotalPassengers = OrigPassengers + TransPassengers; run;

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

A. 100

B. 110

C. 200

D. (missing numeric value)

The following SAS program is submitted:

libname temp `SAS-data-library';

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?

A. Obs newdate qdate ddate 1 APR152000 2 6

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

C. Obs newdate qdate ddate 1 APP152000 2 7

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