Free SASInstitute A00-201 Practice Test & Real Exam Questions
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;
Which one of the following statements explains why the program failed execution?
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;
Which one of the following statements explains why the program failed execution?
Correct Answer: D
Vote an answer
The SAS data set WORK.AWARDS is listed below:
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
Correct Answer: A
Vote an answer
On which portion(s) of a SAS data set does the PRINT procedure report?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
Which one of the following is the value of the variable PROD in the output data set?
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
Which one of the following is the value of the variable PROD in the output data set?
Correct Answer: B
Vote an answer
The following SAS DATA step is submitted:
libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?
libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
data _null_;
set old;
put sales1 sales2;
run;
Where is the output written?
data _null_;
set old;
put sales1 sales2;
run;
Where is the output written?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
Correct Answer: C
Vote an answer
In the following SAS program, the input data files are sorted by the NAMES variable:
libname temp 'SAS-data-library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
Which one of the following results occurs when this program is submitted?
libname temp 'SAS-data-library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
Which one of the following results occurs when this program is submitted?
Correct Answer: A
Vote an answer
The following SAS program is submitted:
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?
Correct Answer: D
Vote an answer
