Our pass rate is high to 98.9% and the similarity percentage between our A00-211 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the SAS Institute A00-211 exam in just one try? I am currently studying for the SAS Institute A00-211 exam. Latest SAS Institute A00-211 Test exam practice questions and answers, Try SAS Institute A00-211 Brain Dumps First.
Q1. Which one of the following is true when SAS encounters a data error in a DATA step?
A. The DATA step stops executing at the point of the error, and no SAS data set is created.
B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
Answer: B
Q2. The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY name age name salary Bruce 30 Bruce 40000 Dan 35 Bruce 35000 Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?
A. 2
B. 4
C. 5
D. 6
Answer: A
Q3. Which ODS statement option terminates output being written to an HTML rile?
A. END
B. QUIT
C. STOP
D. CLOSE
Answer: D
Q4. The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?
A. libname perm 'SAS-data-library'
data _null_;
set perm.jan_sales;
file 'file-specification' dsd = ','
put idnum sales_date : mmddyy10.;
run;
B. libname perm 'SAS-data-library'
data _null_;
set perm.jan_sales;
file 'file-specification' dlm = ','
put idnum sales_date : mmddyy10.;
run;
C. libname perm 'SAS-data-library'
data _null_;
set perm.jan_sales;
file 'file-specification'
put idnum sales_date : mmddyy10. dlm = ','
run;
D. libname perm 'SAS-data-library'
data _null_;
set perm.jan_sales;
file 'file-specification'
put idnum sales_date : mmddyy10. dsd = ','
run;
Answer: B
Q5. Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = ‘HARDWARE’ then output HWARE;
else if producttype = ‘NETWORK’ then output INTER;
else if producttype = ‘SOFTWARE’ then output SOFT;
run;
How many observations does the HWARE data set contain?
A. 0
B. 2
C. 3
D. 4
Answer: B
Q6. The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
What is output?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q7. Given the following data step:
After data step execution, what will data set WORK.GEO contain?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q8. The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
A. The program fails execution due to data errors.
B. The program fails execution due to syntax errors.
C. The program executes with warnings and creates the WORK.TOTALSALES data set.
D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
Answer: B