TestInsides A00-231 Dumps Real Exam Questions Test Engine Dumps Training
SASInstitute A00-231 exam dumps and online Test Engine
The SASInstitute A00-231 certification exam is a challenging and rewarding exam that is designed for experienced SAS programmers who want to demonstrate their knowledge and skills. It is an excellent way to advance your career and increase your value to organizations that use SAS software for data analysis and reporting.
NEW QUESTION # 51
Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis60000
Jolli50000
Ellis55000
Liu45000
The following SAS program is submitted:
proc print data = employees; where name like '_i%';
run;
What is contained in the output?
- A. Liu only
- B. Innis, Ellis, and Liu only
- C. Innis and Ellis only
- D. Innis, Jolli, Ellis, and Liu
Answer: A
NEW QUESTION # 52
The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005.
What output is produced if April 15, 2005 falls on a Friday?
- A. Obs newdate mdate ddate104/15/2005 4 6
- B. Obs newdate mdate ddate104/15/2005 APR 7
- C. Obsnewdate mdate ddate104/15/2005 APR 6
- D. Obs newdate mdate ddate104/15/2005 4 7
Answer: A
NEW QUESTION # 53
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS informat correctly completes the program?
- A. mmddyy10
- B. mondayyr10
- C. date9
- D. ddmmyy10
Answer: A
NEW QUESTION # 54
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
- A. The WORKTOTAL data set contains 500 observations.
- B. The WORKTDTAL data set contains 100 observations.
- C. The program fails to execute due to errors.
- D. The WORK.TOTAL data set contains 5 observations.
Answer: D
NEW QUESTION # 55
The SAS data set BANKS is listed below:
BANKS
name rate
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
The following SAS program is submitted:
data newbank;
do year = 1 to 3;
set banks;
capital + 5000;
end;
run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
- A. 1 observations and 4 variables
- B. 9 observations and 2 variables
- C. 0 observations and 0 variables
- D. 3 observations and 3 variables
Answer: A
NEW QUESTION # 56
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
- A. if end = 0;
- B. if eof = 0;
- C. if end = 1;
- D. if eof = 1;
Answer: D
NEW QUESTION # 57
The contents of the raw data file EMPLOYEE are listed below:
--------10-------20-------30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Sue' then input age 7-8; else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?
- A. . (missing numeric value)
- B. 0
- C. 1
- D. 2
Answer: C
NEW QUESTION # 58
The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?
- A. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
- B. Add the option FORMAT = 7.2 option to the MEANS procedure statement.
- C. Add the option MAXDEC = 2 to the MEANS procedure statement.
- D. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
Answer: C
NEW QUESTION # 59
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?
- A. SASUSER
- B. WORK
- C. HOUSES
- D. REPORT.
Answer: B
NEW QUESTION # 60
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?
- A. the total number of variables
- B. a list of the variables in the order they were created
- C. a list of the variables in alphabetic order
- D. a list of variable names
Answer: B
NEW QUESTION # 61
The following SAS program is submitted:
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
- A. options pagenum = 1;
- B. options reset pagenum = 1;
- C. options pageno = 1;
- D. options reset pageno = 1;
Answer: C
NEW QUESTION # 62
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = 'Unknown';
else if level = 1 then
expertise = 'Low';
else if level = 2 or 3 then
expertise = 'Medium';
else
expertise = 'High';
run;
Which of the following values does the variable EXPERTISE contain?
- A. Low, Medium, High, Unknown, and '' (missing character value)
- B. Low, Medium, High, and Unknown only
- C. Low, Medium, and High only
- D. Low, Medium, and Unknown only
Answer: D
NEW QUESTION # 63
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
- A. ods file html = 'sales.html'; ods file close;
- B. ods html = 'sales.html'; ods html close;
- C. ods file = 'sales.html'; ods file close;
- D. ods html file = 'sales.html'; ods html close;
Answer: D
NEW QUESTION # 64
The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?
- A. LIST
- B. CROSSLIST
- C. NOCOLS
- D. NOCROSSTAB
Answer: B
NEW QUESTION # 65
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?
- A. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
- B. PRODUCT and SALES only
- C. PRODUCT, MONTH, NUM_SOLD and COST only
- D. An incomplete output data set is created due to syntax errors.
Answer: D
NEW QUESTION # 66
The following SAS program is submitted:
data work.totalsales;
set work.monthlysales(keep = year product sales);
retain monthsales {12} ;
array monthsales {12} ;
do i = 1 to 12;
monthsales{i} = sales;
end;
cnt + 1;
monthsales{cnt} = sales;
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 runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations
- C. The program fails execution due to syntax errors.
- D. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
Answer: C
NEW QUESTION # 67
Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- A. both A or C will work.
- B. where Age not between 15 and 16 then Group=1; else Group=2;
- C. if Age not in(15,16) then Group=1; else Group=2;
- D. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
Answer: C
NEW QUESTION # 68
The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = '1001';
Item_Reference = Item'/'Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
- A. . (missing numeric value)
- B. 1001/ 5461
- C. The value can not be determined as the program fails to execute due to errors.
- D. 1001/5461
Answer: C
NEW QUESTION # 69
......
SASInstitute A00-231 (SAS 9.4 Base Programming - Performance-based) certification exam is designed to test the candidate's knowledge and skills in SAS programming. This certification is ideal for programmers who want to validate their expertise in the SAS 9.4 programming language. The exam measures the candidate's ability to write SAS programs, manipulate data, and create basic reports using SAS software.
SASInstitute A00-231: Selling SAS Institute Systems Products and Solutions: https://actualtests.testinsides.top/A00-231-dumps-review.html