SAS Institute A00-231 SAS 9.4 Base Programming — Performance-based exam Online Training
SAS Institute A00-231 Online Training
The questions for A00-231 were last updated at Dec 24,2024.
- Exam Code: A00-231
- Exam Name: SAS 9.4 Base Programming -- Performance-based exam
- Certification Provider: SAS Institute
- Latest update: Dec 24,2024
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
- A . 0
- B . 1
- C . 5
- D . 60
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”.
Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?
- A . proc print data = sasuser.houses; label
price = “Sale Price”;
run; - B . proc print data = sasuser.houses label; label
price “Sale Price”;
run; - C . proc print data = sasuser.houses label; label
price = “Sale Price”;
run; - D . proc print data = sasuser.houses;
price = “Sale Price”;
run;
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
- A . merge work.employeework.salary (fname = name);
- B . merge work.employeework.salary (name = fname);
- C . merge work.employeework.salary (rename = (fname = name));
- D . merge work.employeework.salary (rename = (name = fname));
The following SAS program is submitted:
data test;
set chemists;
jobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
————-
chem2
What is the value of the variable DESCRIPTION?
- A . chem2
- B . Unknown
- C . Senior Chemist
- D . ‘ ‘ (missing character value)
The following SAS program is submitted:
data work. new;
length word $7;
amount = 4;
it amount = 4 then word = ‘FOUR’;
else if amount = 7
then word = ‘SEVEN’;
else word = ‘NONE!!!’;
amount = 7;
run;
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
- A . amount word
4 FOUR - B . amount word
4 NONE!!! - C . amount word
7 FOUR - D . amount word
7 SEVEN
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?
- A . total = cat(’-’, prefix, middle, end);
- B . total = catx(’-’, prefix, middle, end);
- C . total = prefix !!’-’!! middle ‘‘!!’-’!! end;
- D . total = prefix!!’-’!! left(middle)!!’-’!! end;
Given the following code:
proc print data=SASHELP.CLASS(firstobs=5 obs=15);
where Sex=’M’;
run;
How many observations will be displayed?
- A . 11
- B . 15
- C . 10 or fewer
- D . 11 or fewer
Which ODS statement option terminates output being written to an HTML rile?
- A . END
- B . QUIT
- C . STOP
- D . CLOSE
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
- A . libname qtrdata ‘qtr1.xls’;
- B . libname ‘qtr1.xls’ sheets=3;
- C . libname jan feb mar ‘qtr1.xls’;
- D . libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,mar);
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
- A . 0
- B . 1
- C . 5
- D . 60
Latest A00-231 Dumps Valid Version with 262 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
