[Q117-Q140] A00-231 Dumps are Available for Instant Access [2024]

Rate this post

A00-231 Dumps are Available for Instant Access [2024]

Practice with these A00-231 dumps Certification Sample Questions

NEW QUESTION 117
Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

Option A

Option B

Option C

Option D

NEW QUESTION 118
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?

The output displays only a list of the SAS data sets that are contained in the WORK library.

The output displays only the contents of the SAS data sets that are contained in the WORK library.

The output displays only the variables in the SAS data sets that are contained in the WORK library.

The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.

NEW QUESTION 119
Given the SAS data set ONE:
ONE
ObsDte
————-
109JAN2005
212JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:
TWO
ObsDteDay
109JAN20051
12JAN20054
Which expression successfully completed the program and created the variable DAY?

day(dte)

weekday(dte)

dayofweek(dte)

datdif(dte,’01jan2005’d,’act/act’)

NEW QUESTION 120
The following SAS program is submitted:

What is the result?

The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.

The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.

The variable Discount in the output data set is set to zero. No messages are written to the SAS log.

NEW QUESTION 121
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?

total = cat(‘-‘, prefix, middle, end);

total = catx(‘-‘, prefix, middle, end);

total = prefix !!’-‘!! middle ”!!’-‘!! end;

total = prefix!!’-‘!! left(middle)!!’-‘!! end;

NEW QUESTION 122
What is the format for the variableNamein the data setBoth? Select one:

no format defined

$CHAR

$CHAR10

$CHAR15

NEW QUESTION 123
The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?

The variable JCODE is written to the output data set.

The variable JOBCODE is written to the output data set.

Neither variable JCODE nor JOBCODE is written to the output data set.

The program fails to execute due to errors.

NEW QUESTION 124
The following SAS program is submitted:
data work.staff;
JobCategory = ‘FA’;
JobLevel = ‘1’;
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?

FA1

FA 1

” (missing character value)

NEW QUESTION 125
Read the table

The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:

Which TABLES statement(s) completed the program and produced the output?

tables region product;

tables region * product;

tables product * region;

tables product; tables region;

NEW QUESTION 126
The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 – sales4;
run;
Which one of the following represents the variables that are contained in the output data set?

SALES1, SALES2, SALES3, SALES4

AGENTS1, AGENTS2, AGENTS3, AGENTS4

None, the DATA step fails because the ARRAY statement can reference only numeric data.

None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

NEW QUESTION 127
The following SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?

Gender

Department

Gender Department

Department Gender

NEW QUESTION 128
Which one of the following statements is true regarding the name of a SAS array?

It is saved with the data set.

It can be used in procedures.

It exists only for the duration of the DATA step.

It can be the same as the name of a variable in the data set.

NEW QUESTION 129
Which is a valid LIBNAME statement?

libname “_SAS_data_library_location_”;

sasdata libname “_SAS_data_library_location_”;

libname sasdata “_SAS_data_library_location_”;

libname sasdata sas “_SAS_data_library_location_”;

NEW QUESTION 130
The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?

ITEMS

ITEMS1, ITEMS2, ITEMS3

No variables are created because it is a temporary array.

The program fails to execute because there are no variables listed on the ARRAY statement.

NEW QUESTION 131
Scenario:
This project will use data set cert.input12. At any time, you may
save your program as program12 in certprograms.
cert.input12 contains a single observation with two variables:
* salary
* year
Write a SAS program that will:
* Create an output data set results.output12.
* Read cert.input12 as input.
* Increase the salary variable by 5.65% annually until it is
greater than $500,000.
* Increment the year variable by 1 with each annual
increase.
* Create an output data set results.output12 that has one
observation for each value of year. Each observation
should have a year and salary variable.
What is the value of year when the above salary occurs? Enter your numeric answer in the space below.

2027
Explanation:
data results.output12;
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;

NEW QUESTION 132
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

libname sasdata ‘SAS-data-library’;data sasdata.mydata;copy mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;keep mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;save mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;set mydata;run;

NEW QUESTION 133
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in certprograms.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
* Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
* Write only observations that are in both data sets to a
new data set named results.match08.
* Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
* Exclude all variables that begin with
“ex” from results.nomatch08.
How many observations (rows) are inresults.nomatch08?

2
Explanation:
proc sort data=cert.input08b out=work.input08b;
by ID;
run:
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a;
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 2

NEW QUESTION 134
Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

data employees; infile ‘file specification’dlm=’*’; input employee $ bdata: mmddyy10.years; run;

data employees; infile ‘file specification’dsd=’*’; input employee $ bdata mmddyy10.years; run;

data employees; infile ‘file specification’DLM dsd; input employee $ bdata mmddyy10.years; run;

data employees; infile ‘file specification’ dLM=’*’ dsd; input employee $ bdata: mmddyy10.years; run;

NEW QUESTION 135
The following SAS program is submitted:

What is the result?

The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.

The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.

The variable Discount in the output data set is set to zero. No messages are written to the SAS log.

NEW QUESTION 136
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department.
The following SAS program is submitted:

What is the value of the variable Total before the first iteration of the data step?

The value of the first observation’s Wagerate.

Missing

Cannot be determined from the information given

NEW QUESTION 137
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?

libname qtrdata ‘qtr1.xls’;

libname ‘qtr1.xls’ sheets=3;

libname jan feb mar ‘qtr1.xls’;

libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,mar);

NEW QUESTION 138
Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: “Order 9341 shipped on 02FEB2009”.
Which of the following statement will correctly create the value and assign it to Note?

note=catx(”,’Order’,order_id,’shipped on’,input(ship_date,date9.));

note=catx(”,’Order’,order_id,’shipped on’,char(ship_date,date9.));

note=catx(”,’Order’,order_id,’shipped on’,transwrd(ship_date,date9.));

note=catx(”,’Order’,order_id,’shipped on’,put(ship_date,date9.));

NEW QUESTION 139
A user-defined format has been created using the FORMAT procedure. Where is it stored?

in a SAS catalog

in an external binary file

in a SAS dataset in the WORK library

in a SAS dataset in a permanent SAS data library

NEW QUESTION 140
The Excel workbook REGIONS.XLSX contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS XLSX ‘c: data regions.xlsx’;
Which PROC PRINT step correctly displays the NORTH worksheet?

proc print data=MYXLS.’NORTH’e;run;

proc print data=MYXLS.NORTH.XLSX;run;

proc print data=MYXLS.NORTH;run;

proc print data=MYXLS.’NORTH$’n;run;

Loading …

SASInstitute A00-231 (SAS 9.4 Base Programming – Performance-based) Certification Exam is a globally recognized certification that validates the skills and knowledge of individuals in the field of SAS programming. A00-231 exam is designed to test the candidate’s ability to use SAS software to manipulate and manage data, as well as write SAS code that is efficient, accurate, and reliable. The A00-231 exam is a performance-based exam, which means that it measures the candidate’s ability to perform SAS programming tasks in a simulated SAS environment.

Eligibility Criteria For SAS Base Programming Specialist (A00-231) Exam

The eligibility criteria for SAS Base Programming Specialist (A00-231) Exam are as follows: Candidate should have completed high school education or equivalent. The candidate should be proficient in English language. The basic eligibility criteria for the SAS Base Programming Specialist (A00-231) Exam are as follows: The candidate must be a citizen of any country of the world. The candidate must have attained the age of 17 years on or before 31st December of the year in which they are applying for this exam. The candidate must have obtained a minimum score of 50% marks in their qualifying degree/equivalent exam. The candidates who wish to appear for this exam must fulfill the basic minimum education qualification as stated below: A bachelor’s degree or an equivalent degree from an accredited university and related experience may also qualify you to take this exam. All foreign degrees must be evaluated by one of the recognized foreign credential evaluation agencies approved by the Department of Education, or by World Education Services.

Get Instant Access REAL A00-231 DUMP Pass Your Exam Easily: https://www.examcollectionpass.com/SASInstitute/A00-231-practice-exam-dumps.html