SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 131:

  The SAS data set EMPLOYEE_INFO is listed below:

  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;

  run;

  Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

  A. by descending IDNumber Expenses;
  B. by (IDNumber Expenses) descending;
  C. by IDNumber descending Expenses descending;
  D. by descending IDNumber descending Expenses;
  D. by descending IDNumber descending Expenses;

• Question 132:

  The following SAS program is submitted:

  data work.accounting;

  set work.dept1 work.dept2;

  jobcode = `FA1';

  length jobcode $ 8;

  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.

  What is the length of the variable JOBCODE in the output data set?

  A. 3
  B. 5
  C. 7
  D. 8
  B. 5

• Question 133:

  The following SAS program is submitted:

  proc contents data=_all_;

  run;

  Which statement best describes the output from the submitted program?

  A. The output displays only a list of the SAS data sets that are contained in the WORK library.
  B. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
  D. The output displays only the metadata of the SAS data sets that are contained in the WORK library.
  B. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.

• Question 134:

  The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.;

  The following SAS program is submitted:

  

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

  A. LocalFee has format of 9. and CountryFee has a format of 7.
  B. LocalFee has format of 9. and CountryFee has a format of percent7.2
  C. Both LocalFee and CountryFee have a format of percent7.2
  D. The data step fails execution; there is no format for LocalFee.
  C. Both LocalFee and CountryFee have a format of percent7.2

• Question 135:

  Which ODS statement option terminates output being written to an HTML rile?

  A. END
  B. QUIT
  C. STOP
  D. CLOSE
  D. CLOSE

• Question 136:

  Given the following code:

  proc print data=SASHELP.CLASS(firstobs=5 obs=15);

  where Sex='M';

  run;

  How many observations will be displayed?

  A. 11
  B. 15
  C. 10 or fewer
  D. 11 or fewer
  D. 11 or fewer

• Question 137:

  Given the following data set WORK.TOYS:

  

  The following SAS program s submitted:

  data WORK.GROUPS;

  set WORK.TOYS;

  if Product="Cards" then Group_Desc="Indoors";

  else if Product in ("Drum", "Recorder") then Group_Desc="Instruments";

  else if Product="Ball" then Group_Desc="Outdoors";

  run;

  proc print data=WORK.GROUPS noobs;

  run;

  Which output is produced?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 138:

  

  The following SAS program is submitted:

  

  What is the value of the price variable?

  A. No value is stored.
  B. $25.31
  C. . (missing numeric value)
  D. 25.31
  C. . (missing numeric value)

• Question 139:

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

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

  Joe xx

  The following SAS program is submitted:

  data test;

  infile 'namenum';

  input name $ number;

  run;

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

  A. xx
  B. Joe
  C. . (missing numeric value)
  D. The value can not be determined as the program fails to execute due to errors.
  C. . (missing numeric value)

• Question 140:

  The following SAS program is submitted:

  libname company 'SAS-data-library';

  proc sort data = company.payroll;

  by EmployeeIDNumber;

  run;

  Write access has been granted to the COMPANY library.

  Which one of the following represents how the observations are sorted?

  A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
  B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
  C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
  D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
  A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.