Testking Sas a00-211
Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcamptk a00-211 Interactive Testing Engine Included!
70 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
QUESTION 66
The following SAS program is submitted:
proc contents data = sashelp.class varnum;
quit;
What does the VARNUM option print?
A. a list of the variables in alphabetic order
B. a list of variable names
C. the total number of variables
D. a list of the variables in the order they were created
QUESTION 67
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;
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 500 observations.
B. The WORK.TOTAL data set contains 5 observations.
C. The program fails to execute due to errors.
D. The WORK.TOTAL data set contains 100 observations.
Answer: B
QUESTION 68
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = ‘Jan’ then output january;
108 sales = cost * num_sold;
109 keep = product sales;
—–
22
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
A. keep product, sales;
B. keep product sales;
C. keep = product, sales;
D. keep = (product sales);
Answer: B
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
A. The program fails execution because the SAS data sets on the MERGE statement are
in two different libraries.
B. The program fails execution because the same SAS data set is referenced for both read
and write operations.
C. The program executes successfully and a temporary SAS data set is created.
D. The program executes successfully and a permanent SAS data set is created.
Answer: D
To pass the A00-211 exam, you not only have to know the above, but you also have to know how to access data, which means knowing how to use the FORMATTED, LIST, and COLUMN input commands to read raw data files. You will need to know how to use INFILE statement options so you can control processing, as well as the INPUT statement. You will show how to create data structures by knowing how to create a temporary and permanent SAS data set, as well as show how to manipulate the SAS date values. You will need to know how to manage data by using SAS utility procedures, sort observations, conditionally execute SAS statements, modify variable attributes using options and statements in the data step, and work within the program to accumulate sub-totals and totals. You will do need to know how to generate reports of different kinds list lists, summaries, and HTML, by using the PRINT, REPORT, and base procedures. Finally, you will show how to handle and solve programming errors. This includes correcting syntax, logic, and data errors.
Free down:Pass4sure sas a00-211
Free down:Testking a00-211
Related Posts
Related Posts
Tags: a00-211
Leave a Reply