• Print  |
  • Feedback  |

Training & Bookstore

Bookstore Questions?

Quick Search for  Books
 

Related Links

Conversations

linkedin sasCommunity blog YouTube

SAS Training and Books on Facebook

Browse Resources» SAS Certification Prep Guide: Base Programming for SAS 9


Updates for SAS Certification Prep Guide: Base Programming for SAS 9

The following chapter numbers and page numbers apply to SAS Certification Prep Guide: Base Programming, ISBN number 978-1-60764-045-5. You can find the ISBN number on the copyright page. Page numbers in other ISBN versions might vary.

Chapter Page Update
2 56 In the second example for the YEARCUTOFF= option (the second table), the "Interpreted As" value for YEARCUTOFF= 12/07/41 should be 12/07/2041 (and not 12/07/1941).
3 96 In quiz question 7, the word "data" in choice b should be spelled "dat" to create the syntax error. The correct answer is "b."

7. Which of the following programs contains a syntax error?

a. 
proc sort data=sasuser.mysales;
       by region;
run;
b. 
dat sasuser.mysales;
       set mydata.sales99;
run;
c. 
proc print data=sasuser.mysales label;
        label region='Sales Region';
run;
d. none of the above

Note: Some printings of this ISBN edition do not contain this error.
5 167 Under the section Creating the Data Step, 2nd paragraph, the word "STEP" should be "SET" as shown in the following sentence:
"When reading Excel data, use the SET statement to indicate which worksheet in the data set you want to read."
5 171 In the sentence directly above the picture of the Import Wizard screen, the word "Tools" should be "File", as shown in the following sentence:
"To access the Import Wizard, select File -> Import Data."
8 263 In quiz question 6, the correct answer ( C ) should read as follows:

c. a list report that displays a row for each observation in the input data set.

There should be no mention of SUM since the SUM statement is not used in this example.
12 352 The data for "Payroll" in the Selected PDF Variables table should show Salary, not Payroll numbers.
13 383 In the example, the output shown (the final Clinic.Therapy data set) is incorrect. The output should be as follows:
Num Sex
1 M
2 F
3 F
4 M
5 M
6 F
7 F
8 M
14 425 The general form of the PUT function should include "format" (and not "informat"). The syntax for the PUT function should read as as follows:

PUT(source,format)
14 426 In the "Matching the Data Type section" at the bottom of the page, the syntax for the INPUT function should be as follows:

INPUT(source,informat)

14 430 In the example at the bottom of the page, the data set on the PROC PRINT statement should be hrd.nov99 (not hrd.temp), as shown below: 

data hrd.nov99;
   set hrd.temp;
   if year(startdate)=1999 and month(startdate)=11;
proc print data=hrd.tempnov;  
run;







16
499

In the statement,

     array qtr{4} jan apr jul oct;

the name "qtr" should be spelled out as:

     array quarter{4} jan apr jul oct;









16
523

In quiz question 10, the program is missing the CARDS statement that creates the data. The entire program should read as follows:

data coat;
   input category high1-high3 / low1-low3;
   array compare{2,3} high1-high3 low1-low3;
   do i=1 to 2;
      do j=1 to 3;
         compare{i,j}=round(compare{i,j}*1.12);
      end;
   end;
cards;
5555 9 8 7 6
4 3 2 1
8888 21 12 34 64
13 14 15 16
;
run;


Correct answer: b

The nested DO loops indicate that the array is named compare and is a two-dimensional array that has two rows and three columns.






19		
594
WEEKDATEw. should be WORDDATEw. in the syntax section.





21
761
The correct answer for question 9 on page 761 is d (and not b).


And the explanation should read as follows:


The assignment statement that precedes the DO WHILE loop creates the counter variable Month and assigns an initial value of zero to it. Each time the DO WHILE loop executes, the SUM 
statement increments the value of Month by 1.






Appendix 1
677

In the quiz Answer Key, question 1, the data set shown is incorrect. The dataset should be identical to the one shown in the corresponding question 1 in Chapter 1, page 33.


The correct data set is shown below along with the correct answer -  c.






Name
Sex 
Age




Picker
M 
32




Fletcher
  
28




Romano
F 
.




Choi
M 
42







Correct answer: c


Rows in the data set are called observations, and columns are called variables.
Missing values don't affect the structure of the data set.






Appendix 1
685

In the quiz Answer Key, question 7, the word "data" in choice b should be spelled "dat" to create the syntax error.  The correct answer is "b."


7.  Which of the following programs contains a syntax error?






a.	 

proc sort data=sasuser.mysales;
run;


b.	 

dat sasuser.mysales;
set mydata.sales99;
run;


c.	

proc print data=sasuser.mysales label;
label region='Sales Region';
run;


d.
none of the above 





Answer: b


Note: Note: Some printings of this ISBN edition do not contain this error.







Appendix 1
707
In the quiz answer key for Chapter 8, question 6, the correct answer ( C ) should read as follows:



c. 	a list report that displays a row for each observation in the input data set. 



There should be no mention of SUM since the SUM statement is not used in this example. 






Appendix 1
761
In the quiz Answer Key, question 9, the correct answer is d (not b). Also, the explanation for this question is incorrect and should read as follows:


Correct answer: d


The assignment statement that precedes the DO WHILE loop creates the counter variable Month and assigns an initial value of zero to it. Each time the DO WHILE loop executes, the SUM statement 
increments the value of Month by 1.