Online Access Free A00-211 Practice Test

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 5 observations.
• B.The WORKTDTAL data set contains 100 observations.
• C.The program fails to execute due to errors.
• D.The WORKTOTAL data set contains 500 observations.

The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?

• A.(space)
• B.; (semicolon)
• C., (comma)
• D.: (colon)

The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?

• A.The SUM statement produces only subtotals of NUMBER for each value of TYPE.
• B.The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
• C.The SUM statement produces only a grand total of NUMBER.
• D.Nothing is produced by the SUM statement; the program fails to execute.

The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?

• A.7
• B.25
• C.17
• D.6

The following SAS program is submitted:
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Which one of the following is the value of the DATE variable?

• A.a numeric value of 14692, which represents the SAS date value for March 23, 2000
• B.a numeric value of 3232000, which represents the SAS date value for March 23, 2000
• C.a character string with the value '03/23/2000'
• D.a character string with the value '23mar2000'