SASInstitute SAS Base Programming for SAS 9 (A00-211日本語版) - A00-211日本語 Exam Practice Test
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;

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;

Correct Answer: A
Vote an answer

proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;

Correct Answer: D
Vote an answer

----|----10---|----20---|----30
Printing 750

data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;

Correct Answer: D
Vote an answer

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;

Correct Answer: A
Vote an answer

--------10-------20-------30
1999/10/25

data projectduration;
infile 'file-specification';
input date $ 1 - 10;
run;

Correct Answer: A
Vote an answer

data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;

Correct Answer: C
Vote an answer

--------10-------20-------30
72 95

data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;

Correct Answer: B
Vote an answer

data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;

Correct Answer: D
Vote an answer

libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;

Correct Answer: A
Vote an answer

PERM.STUDENTS NAME AGE
--------- ------ Alfred 14
Alice13
Barbara13
Carol14

libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $15. @5 age 2.;
run;

Correct Answer: C
Vote an answer





Correct Answer:
See explanation below.
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12






