Download Full Version A00-211 SAS Institute Exam

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,^=,|,II,

110 run;

What changes should be made to the KEEP statement to correct the errors in the LOG?

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

The following SAS program is submitted, creating the SAS data set ONE:

data one;

infile ‘file specification’;

input num chars$;

run;

ONE

NUMCHAR

----------------

123

323

177

The following SAS program is submitted:

proc print data = one;

where char = 23;

run;

What is output?

The following SAS program is submitted:

proc sort data = work.employee;

by descending fname;

proc sort data = work.salary;

by descending fname;

data work.empdata;

merge work.employee

work.salary;

by fname;

run;

Why does the program rail to execute?