Latest SASInstitute A00-231 PDF and Dumps (2023) Free Exam Questions Answers
Pass Your SAS Institute Systems A00-231 Exam on Nov 16, 2023 with 265 Questions
SASInstitute A00-231 certification is highly valued in the industry, and it can open up many career opportunities for SAS programmers. Employers are always looking for certified SAS programmers who have proven their expertise in SAS programming. SAS 9.4 Base Programming - Performance-based exam certification can also help SAS programmers to advance their careers and increase their earning potential.
SASInstitute A00-231 exam is one of the most recognized and respected certification exams in the field of SAS programming. A00-231 exam is designed for professionals who want to demonstrate their proficiency in SAS 9.4 base programming. The A00-231 exam is performance-based, which means that it evaluates your ability to apply your knowledge and skills to real-world scenarios.
NEW QUESTION # 70
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 71
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);
Answer: A
NEW QUESTION # 72
This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:
Which statement was used to complete the above program that produced the output?
- A. tables region product;
- B. var region product;
- C. tables region*product;
- D. var region * product;
Answer: C
NEW QUESTION # 73
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement.
Which statement regarding this variable is true?
- A. It is assigned a value of missing when the data step begins execution.
- B. It is assigned a value 0 at compile time.
- C. It is assigned a value 0 when the data step begins execution.
- D. It is assigned a value of missing at compile time.
Answer: B
NEW QUESTION # 74
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?
- A. 0
- B. Italy
- C. 1
- D. Russia
Answer: A
NEW QUESTION # 75
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then'
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?
- A. 0
- B. 1
- C. (missing numeric value)
- D. 2
Answer: B
NEW QUESTION # 76
A raw data file is listed below:
--------10-------20-------30
squash 1.10
apples 2.25
juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification';
input item $ cost;
run;
Which one of the following completes the program and produces a grand total for all COST values?
- A. grandtot = sum cost;
- B. grandtot = sum(grandtot,cost);
- C. retain grandtot 0;grandtot = sum(grandtot,cost);
- D. grandtot = sum(grandtot,cost);output grandtot
Answer: C
NEW QUESTION # 77
This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?
- A. variable 1: Department variable 2: Department
- B. variable 1: Gender variable 2: Department
- C. variable 1: Department variable 2: Gender
- D. variable 1: Gender variable 2: Gender
Answer: D
NEW QUESTION # 78
How many of the following SAS data set names are valid?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 79
Which ODS statement option terminates output being written to an HTML rile?
- A. END
- B. STOP
- C. QUIT
- D. CLOSE
Answer: D
NEW QUESTION # 80
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?
- A. a missing value due to syntax errors
- B. the character value "01011960"
- C. the numeric value 0
- D. the step will not compile because of the character argument in the mdy function.
Answer: C
NEW QUESTION # 81
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
- A. Option C
- B. Option A
- C. Option B
- D. Option D
Answer: A
NEW QUESTION # 82
The SASDATA.BANKS data set has five observations when the following SAS program is submitted:
libname sasdata 'SAS-data-library';
data allobs;
set sasdata.banks;
capital=0;
do year = 2000 to 2020 by 5;
capital + ((capital+2000) * rate);
output;
end;
run;
How many observations will the ALLOBS data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 83
The contents of the raw data file FURNITURE are listed below:
--------10-------20-------30
chair,,table
chair,couch,table
The following SAS program is submitted:
data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;
Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?
- A. ,table
- B. table
- C. '' (missing character value)
- D. . (missing numeric value)
Answer: C
NEW QUESTION # 84
The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end;
run;
Which one of the following is the value of the variable CALLS in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 85
The contents of the raw data file SIZE are listed below:
--------10-------20-------30
72 95
The following SAS program is submitted:
data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?
- A. .(missing numeric value)
- B. 0
- C. 1
- D. 2
Answer: B
NEW QUESTION # 86
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
- A. No output is generated.
- B. NUM CHAR 1 23 3 23 1 77
- C. NUM CHAR 1 77 2
- D. NUM CHAR 1 23 3 23
Answer: A
NEW QUESTION # 87
The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?
- A. Hemingwa
- B. Hemingway
- C. '' (a missing value)
- D. The program contains errors. No variables are created.
Answer: A
NEW QUESTION # 88
The following SAS program is submitted:
What is the value of the price variable?
- A. . (missing numeric value)
- B. 25.31
- C. No value is stored.
- D. $25.31
Answer: A
NEW QUESTION # 89
Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE
---------------- Alfred14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?
- A. put
- B. put/;
- C. double;
- D. put _null_;
Answer: A
NEW QUESTION # 90
Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO:
The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
- A. Option C
- B. Option A
- C. Option B
- D. Option D
Answer: A
NEW QUESTION # 91
Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
- A. ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112
- B. ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17
- C. ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24
- D. ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17
Answer: D
NEW QUESTION # 92
The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
- A. Wang 3Wang 2Wang 1Gerard 3Amy 2Amy 1
- B. Wang 1Wang 2Wang 3Gerard 3Amy 1Amy 2
- C. Wang 3Gerard 3Wang 2Amy 2Wang 1Amy 1
- D. Wang 3Wang 1Wang 2Gerard 3Amy 2Amy 1
Answer: B
NEW QUESTION # 93
......
A00-231 Dumps for SAS Institute Systems Certified Exam Questions and Answer: https://www.testkingfree.com/SASInstitute/A00-231-practice-exam-dumps.html
A00-231 Free Exam Study Guide! (Updated 265 Questions): https://drive.google.com/open?id=1_bdvz7w3vAENoU07M8_0YvolHLyUeICv