SASInstitute SAS Base Programming for SAS 9 - A00-211 FREE EXAM DUMPS QUESTIONS & ANSWERS
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
Correct Answer: C
Vote an answer
The following GAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?
Correct Answer: C
Vote an answer
Given the following SAS log entry:
What caused the error?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
data combine;
prefix='505';
middle='6465 ';
end='09090';
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-
09090?
data combine;
prefix='505';
middle='6465 ';
end='09090';
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-
09090?
Correct Answer: D
Vote an answer
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
libname temp 'SAS-data-library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?
libname temp 'SAS-data-library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?
Correct Answer: A
Vote an answer
Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?
Correct Answer: C
Vote an answer
The following SAS program is submitted;
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
Correct Answer: D
Vote an answer
The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:
Correct Answer: A
Vote an answer
Given the SAS data set WORK. PRODUCTS:
The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns);
Revenue-Price* (Sales-Returns);
run;
How many variables does the WORK.REVENUE data set contain?
The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns);
Revenue-Price* (Sales-Returns);
run;
How many variables does the WORK.REVENUE data set contain?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
What value will SAS assign to Pos? Enter your numeric answer in the space below.
What value will SAS assign to Pos? Enter your numeric answer in the space below.
Correct Answer:
12
The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
Correct Answer: C
Vote an answer