A00-231 Practice Test Give You First Time Success with 100% Money Back Guarantee!

All Obstacles During A00-231 Exam Preparation with A00-231 Real Test Questions

SASInstitute A00-231 (SAS 9.4 Base Programming - Performance-based) Certification Exam is an industry-recognized certification that validates the skills and knowledge of SAS programmers. A00-231 exam is designed to test the proficiency level of candidates in SAS 9.4 Base Programming and assess their ability to write and debug SAS code, manipulate data, and generate reports. SAS 9.4 Base Programming - Performance-based exam certification exam is performance-based, which means that candidates are required to perform tasks in a simulated SAS environment.

 

NEW QUESTION # 124
Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
2
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. 1
• C. 2
• D. 3

Answer: D

NEW QUESTION # 125
The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars'; proc print data = sasuser.shoes; footnote2 'All Products'; run; Which footnote(s) is/are displayed in the report?

• A. All Products All Regions All Figures in Thousands of Dollars
• B. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
• C. Sales Report for Last Month All Products
• D. All Products

Answer: C

NEW QUESTION # 126
The following SAS program is submitted:

What is the initial value of the variable Total in the following program?

• A. 0
• B. Missing
• C. Cannot be determined from the information given
• D. The value of the first observations Wagerate

Answer: B

NEW QUESTION # 127
The following SAS program is submitted:
data WORK.ONE;
Text='Australia, US, Denmark';
Pos=find (Text,'US','i',5);
run;
What value will SAS assign to Pos?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: C

NEW QUESTION # 128
A user-defined format has been created using the FORMAT procedure.
How is it stored?

• A. in a SAS catalog
• B. in a SAS dataset in a permanent SAS data library
• C. in a memory resident lookup table
• D. in a SAS data set in the WORK library

Answer: A

NEW QUESTION # 129
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: Gender variable 2: Gender
• B. variable 1: Gender variable 2: Department
• C. variable 1: Department variable 2: Gender
• D. variable 1: Department variable 2: Department

Answer: A

NEW QUESTION # 130
Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO
IDNumber
Expenses
2542
100.00
3612
133.15
2198
234.34
2198
111.12
The following SAS program is submitted:
proc sort data = employee_info;
<insert BY statement here>
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

• A. by ascending Expenses IDNumber;
• B. by Expenses IDNumber;
• C. by ascending IDNumber ascending Expenses;
• D. by IDNumber Expenses;

Answer: D

NEW QUESTION # 131
Given the SAS data set QTR 1_REVENUE:
destination revenue
YYZ53634
FRA62129
FRA75962
RDU76254
YYZ82174
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue; run;
What is the first observation in the output data set?

• A. destination revenue FRA 62129
• B. destination revenue YYZ 53634
• C. destination revenue FRA 75962
• D. destination revenue YYZ 82174

Answer: C

NEW QUESTION # 132
Given the SAS data set AGES:
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: D

NEW QUESTION # 133
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; price = "Sale Price"; run;
• B. proc print data = sasuser.houses; label price = "Sale Price"; run;
• C. proc print data = sasuser.houses label; label price = "Sale Price"; run;
• D. proc print data = sasuser.houses label; label price "Sale Price"; run;

Answer: C

NEW QUESTION # 134
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:

The following program is submitted:

Which statement should be inserted to produce the following output?

• A. Qtr1 = month{1} + month{2} + month {3};
• B. Qtr1 = sum(of month{_ALL_});
• C. Qtr1 = sum(of month {3});
• D. Qtr1 = sum(of month {*});

Answer: D

NEW QUESTION # 135
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. . (missing numeric value)
• B. '' (missing character value)
• C. table
• D. ,table

Answer: B

NEW QUESTION # 136
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.; The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

• A. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
• B. The data step fails execution; there is no format for LOCALFEE
• C. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
• D. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.

Answer: A

NEW QUESTION # 137
The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

NEW QUESTION # 138
The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?

• A. of
• B. '' (missing character value)
• C. Dickens
• D. T

Answer: B

NEW QUESTION # 139
The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

• A. 50.5
• B. . (missing numeric value)
• C. Pass
• D. Fail

Answer: A

NEW QUESTION # 140
Given the following SAS data set WORK.EMPDATA:

Which WERE statement would display observations wit Job_Title containing the word "Manager"?

• A. where Job_Title like 'Manager%';
• B. where substr(Job_Title, (length(Job_Title)-6))='Manager';
• C. where Job_Title='% Manager ';
• D. where upcase(scan(Job_Title,-1,' '))='MANAGER';

Answer: C

NEW QUESTION # 141
Given the following raw data record:
----I----10---I----20---I----30
son Travis,
The following output is desired:
Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?

• A. data family; infile 'file specification'; input relation $ firstname $ / dim = ','; run;
• B. data family ( dIm = ','); infile 'tile specification'; input relation $ firstname $; run;
• C. data family; infile 'file specification' dIm = ','; input relation $ firstname $; run;
• D. options dIm = ','; data family; infile 'file specification'; input relation $ firstname $; run;

Answer: C

NEW QUESTION # 142
Which ODS statement option terminates output being written to an HTML rile?

• A. END
• B. STOP
• C. CLOSE
• D. QUIT

Answer: C

NEW QUESTION # 143
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?

• A. department=trim(dept)||put(number,3.);
• B. department = left(dept) II number;
• C. department = trim(dept) number;
• D. department = dept II number;

Answer: A

NEW QUESTION # 144
The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

NEW QUESTION # 145
Which statement correctly computes the average of four numerical values?

• A. average = mean(num1, num4);
• B. average = mean(ofnum1 - num4)
• C. average = mean(num1 num2 num3 num4);
• D. average = mean(num1 - num4);

Answer: B

NEW QUESTION # 146
Given the SAS data set WORK.ORDERS:

Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?

• A. Ship_date_char = input(Ship_date,worddate20.);
• B. Ship_date_char = input(Ship_date, date9.,worddate20.);
• C. Ship_date_char = put(Ship_date, date9.,worddate20.);
• D. Ship_date_char = put(Ship_date,worddate20.);

Answer: D

NEW QUESTION # 147
The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10
Which one of the following SAS programs created this data set?

• A. data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff = 10;end;elsedo;airplanetype = 'Small';staff = 5;end;run;
• B. data work.test;capacity = 150;if 100 le capacity le 200 then;airplanetype = 'Small';staff = 5;else;airplanetype = 'Large';staff = 10;run;
• C. data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff = 10;elsedo;airplanetype = 'Small';staff = 5;end;run;
• D. data work.test;capacity = 150;if 100 le capacity le 200 thenairplanetype = 'Large' and staff = 10;else airplanetype = 'Small' and staff = 5;run;

Answer: A

NEW QUESTION # 148
The following SAS program is submitted:

The program fails execution due to syntax errors.
What is the cause of the syntax error?

• A. The KEEP= data set option should be (KEEP = MONTHSALES).
• B. An array cannot be referenced on a KEEP data set option.
• C. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
• D. The variable MONTHSALES does not exist.

Answer: B

NEW QUESTION # 149
......

Fully Updated Free Actual SASInstitute A00-231 Exam Questions: https://www.vce4dumps.com/A00-231-valid-torrent.html

Free A00-231 Questions for SASInstitute A00-231 Exam [Dec-2023]: https://drive.google.com/open?id=1XRH0SV6Q_gpe5Bimo0BOHXowXH9J5gbQ