Testpassport A00-211 Exam Features

1. The following SAS program is submitted:

What are the length and value of the CITY variable?
A.length of 6, value of CPH
B.length of 9, value of CPH
C.length of 6, value of ' ' (missing character value)
D.length of 9, value of ' ' (missing character value)
Answer: C

2. Given the SAS data set SASUSER.HOUSES:

The following SAS program is submitted:
The following output is desired:

Which DEFINE statement completes the program and produces the desired output?
A.define style / width = 9;
B.define style / order width = 9;
C.define style / group width = 9;
D.define style / display width = 9;
Answer: C

3. The following SAS program is submitted:

The variable NEWDATE contains the SAS date value for April 15, 2005.
What output is produced if April 15, 2005 falls on a Friday?
A.Obs newdate mdate ddate
  1 04/15/2005 APR 6
B.Obs newdate mdate ddate
  1 04/15/2005 4 6
C.Obs newdate mdate ddate
  1 04/15/2005 APR 7
D.Obs newdate mdate ddate
  1 04/15/2005 4 7
Answer: B

4. What is the purpose of the END= option on the INFILE statement?
A.It identifies the last record read in a raw data file.
B.It identifies the last DATA step statement to be executed.
C.It identifies the length of the record that is being processed.
D.It moves the end of record marker to the length specified by the logical record length.
Answer: A

5. The following SAS program is submitted:

What is the value of the variable PROD in the output data set?
A.6
B.7
C.8
D.. (missing numeric)
Answer: B

6. Given the SAS data set ONE:

Which report is produced?
A.X Y Z
  1 A 27
  1 B 45
  2 A 52
  2 B 69
  3 B 70
  4 A 82
  4 C 91
B.X Y Z
  1 A 33
  1 B 45
  2 A 52
  2 B 69
  3 B 70
  4 A 82
  4 C 91
C.X Y Z
  1 B 45
  2 A 52
  2 B 69
  3 B 70
  4 A 82
  4 C 91
D.The PRINT procedure fails because the data set TWO is not created in the DATA step.
Answer: A

7. Given the raw data file YEARAMT:

What is the value of the variable TOTQUANTITY in the second observation?
A.0
B.1
C.3
D.. (missing numeric)
Answer: D

8. Given the contents of the raw data file PRODUCT:

What is the value of the PRICE variable?
A.25.31
B.$25.31
C.. (missing numeric value)
D.No value is stored.
Answer: C
9. Given the contents of the raw data file TYPECOLOR:

What are the values of the variables TYPE and COLOR?
A.type color
  daisyyellow
B.type color
  daisyellow
C.type color
  daisyyellow" " (missing character value)
D.No values are stored for the TYPE and COLOR variables.
Answer: B

10. The following SAS program is submitted and reads 100 records from a raw data file:

Which IF statement writes the final observation to the output data set?
A.if eof = 0;
B.if last = 0;
C.if end = 1;
D.if eof = 1;
Answer: D

11. Given the raw data file FURNITURE:

What is the value of the variable ITEM2 in the first observation of the output data set?
A.table
B., (comma)
C.. (missing numeric value)
D.' ' (missing character value)
Answer: D

12. The following SAS program is submitted:

How many raw data records are read during each iteration of the DATA step execution?
A.1
B.2
C.3
D.4
Answer: A

13. The following SAS program is submitted:

The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
A.0
B.5
C.7
D.12
Answer: A

14. Given the SAS data sets EMPLOYEE and SALARY:

How many observations will the data set WORK.EMPSALARY contain?
A.2
B.4
C.5
D.6
Answer: B

15. Given the SAS data sets EMPLOYEE and SALARY:

Which MERGE statement correctly completes the program?
A.merge employee
  salary rename = fname = name;
B.merge employee
  salary rename(name = fname);
C.merge employee
  salary (rename = (fname = name));
D.merge employee
  salary (rename = (name = fname));
Answer: D

16. Given the following raw data record:
07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?
A.dmy9.
B.date9.
C.ddMMMyy9.
D.ddmmmyyyy9.
Answer: B

17. Given the contents of the SAS data set PERM.JAN_SALES:

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 SAS program 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. ;
  run;
D.libname perm 'SAS data library';
  data _null_;
  set perm.jan_sales;
  file 'file specification' csv;
  put idnum sales_date : mmddyy10. ;
  run;
Answer: B

18. The following SAS program is submitted:
data _null_;
set old;
put sales1 sales2;
run;
Where is the output written?
A.to the SAS log
B.to the SAS data set _NULL_
C.to the SAS output window or to an output file
D.to the raw data file that was most recently opened
Answer: A

19. The following SAS program is submitted:

The data set PRDSALES contains 5000 observations.
How many observations are processed by each procedure?
A.400 by PROC PRINT
  4500 by PROC MEANS
B.401 by PROC PRINT
  4501 by PROC MEANS
C.400 by PROC PRINT
  0 by PROC MEANS
D.500 by PROC PRINT
  5000 by PROC MEANS
Answer: B

20. Given the following raw data file:
----|----10---|----20---|----30

What is the result?
A.The WORK.HOMEWORK data set is created and contains 1 observation.
B.The WORK.HOMEWORK data set is created and contains 2 observations.
C.The WORK.HOMEWORK data set is created and contains 3 observations.
D.The WORK.HOMEWORK data set is not created. The program fails to execute due to errors.
Answer: B

21. Given the SAS data set WORK.AWARDS:

How are the observations sorted?
A.FNAMEPOINTSMONTH
  Wang 3 3
  Wang 1 12
  Wang 1 8
  Gerard 3 3
  Amy 2 4
  Amy 1 7
B.FNAMEPOINTSMONTH
  Amy 2 4
  Amy 1 7
  Gerard 3 3
  Wang 3 3
  Wang 1 8
  Wang 1 12
C.FNAMEPOINTSMONTH
  Wang 3 3
  Wang 1 8
  Wang 1 12
  Gerard 3 3
  Amy 2 4
  Amy 1 7
D.FNAMEPOINTSMONTH
  Wang 1 12
  Wang 1 8
  Wang 3 3
  Gerard 3 3
  Amy 1 7
  Amy 2 4
Answer: D

22. Given the SAS data set QTR1_REVENUE:
destination revenue
YYZ 53634

What is the first observation in the output data set?
A.destination revenue
  FRA 62129
B.destination revenue
  FRA 75962
C.destination revenue
  YYZ 53634
D.destination revenue
  YYZ 82174
Answer: B

23. The following SAS program is submitted:

What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
A.amount word
  4 FOUR
B.amount word
  4 NONE!!!
C.amount word
  7 FOUR
D.amount word
  7 SEVEN
Answer: C

24. The following SAS program is submitted:

What is the result?
A.The value of the variable Z is 8. No error or warning messages are written to the SAS log.
B.The value of the variable Z is 9. No error or warning messages are written to the SAS log.
C.The value of the variable Z is 6. A warning message indicating that the second asterisk is ignored is written to the SAS log.
D.The variable Z is not created. The program fails to execute due to errors.
Answer: B

25. The following SAS program is submitted:

What is the value of the variable JOBCATEGORY in the output data set?
A.FA
B.FA1
C.FA 1
D.FA||1
Answer: A

26. The following SAS program is submitted:

What is the value of the TOTALPASSENGERS variable in the output data set?
A.0
B.100
C.200
D. (missing numeric value)
Answer: B

27. The following SAS program is submitted:

What is the result?
A.Only the variable JCODE is written to the output data set.
B.Only the variable JOBCODE is written to the output data set.
C.The variables JCODE and JOBCODE are both written to the output data set.
D.The program fails to execute due to errors.
Answer: B

28. The following SAS program is submitted:

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?
A.The length of the variable JOBCODE is 3.
B.The length of the variable JOBCODE is 5.
C.The length of the variable JOBCODE is 12.
D.The program fails to execute due to errors.
Answer: B

29. The following SAS program is submitted:

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
Answer: B

30. The following SAS program is submitted:

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
A.The WORK.TOTAL data set contains 5 observations.
B.The WORK.TOTAL data set contains 100 observations.
C.The WORK.TOTAL data set contains 500 observations.
D.The program fails to execute due to errors.
Answer: A