Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (A 61-70)

61: Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

A.libname sasdata ‘SAS-data-library’;
data sasdata.mydata;
copy mydata;
run;
B.libname sasdata ‘SAS-data-library’;
data sasdata.mydata;
keep mydata;
run;
C.libname sasdata ‘SAS-data-library’;
data sasdata.mydata;
save mydata;
run;
D.libname sasdata ‘SAS-data-library’;
data sasdata.mydata;
set mydata;
run;
Answers: D

62: The following SAS program is submitted:

data work.new;
     mon  = 3;
     day  = 23;
     year = 2000;
     date = mdy(mon,day,year);
run;

Which one of the following is the value of the DATE variable?
A.a character string with the value ’23mar2000′
B.a character string with the value ’03/23/2000′
C.a numeric value of 14692, which represents the SAS date value for March 23, 2000
D.a numeric value of 3232000, which represents the SAS date value for March 23, 2000
Answers: C

63: The following SAS program is submitted:

proc report data = sasuser.houses nowd headline headskip;
    column style price;
    where price < 100000;
    <insert code here>
    title;
run;

Click the Exhibit button to view the output from the REPORT procedure.
Assuming that the PRICE variable is numeric, which one of the following completes the program and produces the output displayed in the exhibit?
clip_image001
A.define style / group ‘Style’;
define price / mean ‘Price’ format = dollar9.;
B.define style / display ‘Style’;
define price / across ‘Price’ format = dollar9.;
C.define style / display ‘Style’;
define price / sum ‘Price’ format = dollar9.;
D.define style / order ‘Style’;
define price / mean ‘Price’ format = dollar9.;
Answers: C

64: A raw data file is listed below:
 
—-|—-10—|—-20—|—-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;
     <insert statement(s) here>
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;
Answers: C

65: Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
A.non-missing numeric variable values only
B.missing numeric variable values and non-missing numeric variable values only
C.non-missing character variables and non-missing numeric variable values only
D.missing character variables, non-missing character variables, missing numeric variable values, and non-missing numeric variable values
Answers: A

66: The following SAS program is submitted:

proc print data = sasuser.houses;
run;
<insert OPTIONS statement here>
proc means data = sasuser.shoes;
run;

Which one of the following OPTIONS statements resets the page number to 1 for the second report?
A.options pageno = 1;
B.options pagenum = 1;
C.options reset pageno = 1;
D.options reset pagenum = 1;
Answers: A

67: The contents of the raw data file EMPLOYEE are listed below:

—-|—-10—|—-20—|—-30
Ruth  39 11
Jose  32 22
Sue   30 33
John  40 44

The following SAS program is submitted:

data test;
      infile ’employee’;
      input employee_name $ 1-4;
      if employee_name = ‘Sue’ then input age 7-8;
      else input idnum 10-11;
run;

Which one of the following values does the variable AGE contain when the name of the employee is “Sue”?
A.30
B.33
C.40
D.. (missing numeric value)
Answers: C

68: The SAS data set BANKS is listed below:
clip_image001[4]
The following SAS program is submitted:

data newbank;
     do year = 1 to 3;
          set banks;
          capital + 5000;
     end;
run;

Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
A.0 observations and 0 variables
B.1 observations and  4 variables
C.3 observations and 3 variables
D.9 observations and 2 variables
Answers: B

69: The following SAS program is submitted:

data work.passengers;
      if OrigPassengers = . then
         OrigPassengers = 100;
      TransPassengers = 100;
      OrigPassengers = .;
      NonPaying = 10;
      TotalPassengers = sum (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)
Answers: A

70: The contents of the raw data file TYPECOLOR are listed below:

—-|—-10—|—-20—|—-30
daisyyellow
The following SAS program is submitted:
data flowers;
     infile ‘typecolor’;
     input type $ 1-5 +1 color $;
run;

Which one of the following represents the values of the variables TYPE and COLOR?
clip_image001[6]
Answers: B

If you want to pass the SAS A00-201 exam sucessfully, recommend to read latest SAS A00-201 Braindumps full version.