Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (A 51-60)

51: The contents of the SAS data set PERM.JAN_SALES are listed below:

A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?
A.libname perm ‘SAS-data-library’;
data _null_;
set perm.jan_sales;
file ‘file-specification’ dsd = ‘,’;
put idnum sales_date : mmddyy10.;
run;
B.libname perm ‘SAS-data-library’;
data _null_;
set perm.jan_sales;
file ‘file-specification’ dlm = ‘,’;
put idnum sales_date : mmddyy10.;
run;
C.libname perm ‘SAS-data-library’;
data _null_;
set perm.jan_sales;
file ‘file-specification’;
put idnum sales_date : mmddyy10. dlm = ‘,’;
run;
D.libname perm ‘SAS-data-library’;
data _null_;
set perm.jan_sales;
file ‘file-specification’;
put idnum sales_date : mmddyy10. dsd = ‘,’;  
put idnum sales_date : mmddyy10. dsd = ‘,’;
run;
Answers: B

52: The contents of the raw data file AMOUNT are listed below:

—-|—-10—|—-20—|—-30
$1,234

The following SAS program is submitted:

data test;
      infile ‘amount’;
      input @1 salary 6.;
run;

Which one of the following is the value of the SALARY variable?
A.1234
B.1,234
C.$1,234
D.. (missing numeric value)
Answers: D

53: The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”.
Which one of the following SAS programs temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?
A.proc print data = sasuser.houses;
label price = “Sale Price”;
run;
B.proc print data = sasuser.houses label;
label price “Sale Price”;
run;
C.proc print data = sasuser.houses label;
label price = “Sale Price”;
run;
D.proc print data = sasuser.houses label = “Sale Price”;
run;
Answers: C

54: The following SAS program is submitted:

data work.accounting;
     set work.dept1 work.dept2;
run;

A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets.  The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
Which one of the following is the length of the variable JOBCODE in the output data set?
A.5
B.7
C.8
D.12
Answers: A

55: Which one of the following statements is true regarding the SAS automatic _ERROR_  variable?
A.The _ERROR_  variable contains the values ‘ON’ or ‘OFF’.
B.The _ERROR_  variable contains the values ‘TRUE’ or ‘FALSE’.
C.The _ERROR_  variable is automatically stored in the resulting SAS data set.
D.The _ERROR_  variable can be used in expressions or calculations in the DATA step.
Answers: D

56: The following SAS program is submitted:

data work.sales;
      do year = 1 to 5;
           do month = 1 to 12;
                 x + 1;
       end;
run;

Which one of the following represents how many observations are written to the WORK.SALES data set?
A.0
B.1
C.5
D.60
Answers: B

57: The SAS data set WORK.AWARDS is listed below:

The following SAS program is submitted:

proc sort data = work.awards;
      by descending fname points;
run;

Which one of the following represents how the observations are sorted?
A.Wang    3
Gerard  3
Wang    2
Amy     2
Wang    1
Amy     1
B.Wang    3
Wang    2
Wang    1
Gerard  3
Amy     2
Amy     1
C.Wang    3
Wang    1
Wang    2
Gerard  3
Amy     2
Amy     1
D.Wang    1
Wang    2
Wang    3
Gerard  3
Amy     1
Amy     2
Answers: D

58: The following SAS program is submitted:

proc contents data = sasuser.airplanes;
run;

Which one of the following is produced as output?
A.the data portion of every data set in the SASUSER library
B.the data portion of the data set SASUSER.AIRPLANES only
C.the descriptor portion of every data set in the SASUSER library
D.the descriptor portion of the data set SASUSER.AIRPLANES only
Answers: D

59: The following SAS program is submitted:

data work.company;
     set work.dept1(keep = jobcode)
     work.dept2(rename = (jcode = jobcode));
run;

Which one of the following is the result?
A.The variable JCODE is written to the output data set.
B.The variable JOBCODE is written to the output data set.
C.Neither variable JCODE nor JOBCODE is written to the output data set.
D.The program fails to execute due to errors.
Answers: B

60: The following SAS program is submitted:

data work.test;
     Author = ‘Christie, Agatha’;
     First = substr(scan(author,2,’ ,’),1,1);
run;

Which one of the following is the value of the variable FIRST in the output data set?
A.A
B.C
C.Agatha
D.’ ‘ (missing character value)
Answers: A

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