SAS Institute A00-211 SAS Base Programming for SAS 9 Online Training
SAS Institute A00-211 Online Training
The questions for A00-211 were last updated at Jan 03,2025.
- Exam Code: A00-211
- Exam Name: SAS Base Programming for SAS 9
- Certification Provider: SAS Institute
- Latest update: Jan 03,2025
The following SAS program is submitted:
data ONE TWO SASUSER.TWO
set SASUSER.ONE;
run;
Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
- A . 2 temporary and 1 permanent SAS data sets are created
- B . 3 temporary and 2 permanent SAS data sets are created
- C . 2 temporary and 2 permanent SAS data sets are created
- D . there is an error and no new data sets are created
The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
- A . 6
- B . 7
- C . 8
- D . (missing numeric)
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS ‘regions.xls’;
Which PROC PRINT step correctly displays the NORTH worksheet?
- A . proc print data=MYXLS.NORTH;run;
- B . proc print data=MYXLS.NORTH$;run;
- C . proc print data=MYXLS.’NORTH’e;run;
- D . proc print data=MYXLS.’NORTH$’n;run;
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:
- A . var Height / nobs min max mean maxdec=1;
- B . proc means data=SASHELP.CLASS maxdec=1 ;
- C . proc means data=SASHELP.CLASS min max mean maxdec=1;
- D . output nobs min max mean maxdec=1;
Which is a valid LIBNAME statement?
- A . libname "_SAS_data_library_location_";
- B . sasdata libname "_SAS_data_library_location_";
- C . libname sasdata "_SAS_data_library_location_";
- D . libname sasdata sas "_SAS_data_library_location_";
What describes the SAS automatic _ERROR_ variable?
- A . The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’
- B . The _ERROR variable maintains a count of the number of data errors.
- C . The _ERROR_ variable can be used in expressions or calculations in the DATA step.
- D . The ERROR_variable contains the number or the observation that caused the error.
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 a grand total of NUMBER.
- B . The SUM statement produces only subtotals of NUMBER for each value of TYPE.
- C . The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
- D . Nothing is produced by the SUM statement; the program fails to execute.
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
——– ——
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?
- A . MPG is not a numeric variable.
- B . LOAD is not a variable in the data set GT100.
- C . LOAD is not variable in the data set AIRPLANES.
- D . LOAD must be defined prior to the SET statement.
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
– style price
– CONDO$79,700
– TWOSTORY$62550
Which DEFINE statement completes the program and produces the desired output?
- A . define style / width = 9,
- B . define style / order width = 9;
- C . define style / group width = 9;
- D . define style / display width = 9;
What is the purpose or the MISSOVER option on the INFILE statement?
- A . It prevents SAS from loading a new record when the end of the current record is reached.
- B . It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’ expression is round.
- C . It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
- D . It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.
Latest A00-211 Dumps Valid Version with 270 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
