Updated Oct-2023 100% Cover Real A00-231 Exam Questions Make Sure You 100% Pass
A00-231 dumps Accurate Questions and Answers with Free and Fast Updates
NEW QUESTION # 134
After a SAS program is submitted, the following is written to the SAS log:
What changes should be made to the KEEP statement to correct the errors in the LOG?
- A. keep=(Product Sales);
- B. keep Product Sales;
- C. keep=Product, Sales;
- D. keep Product, Sales;
Answer: B
NEW QUESTION # 135
The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?
- A. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;
- B. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dsd = ','; put idnum sales_date : mmddyy10.; run;
- C. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dlm = ','; run;
- D. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;
Answer: D
NEW QUESTION # 136
The contents of the raw data file AMOUNT are listed below:
--------10-------20-------30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input @1 salary 6.;
if _error_ then description = 'Problems';
else description = 'No Problems';
run;
Which one of the following is the value of the DESCRIPTION variable?
- A. No Problems
- B. Problems
- C. '' (missing character value)
- D. The value can not be determined as the program fails to execute due to errors.
Answer: B
NEW QUESTION # 137
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
- A. No output is generated
Answer: A
NEW QUESTION # 138
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. Innis and Ellis only
- B. Innis, Jolli, Ellis, and Liu
- C. Liu only
- D. Innis, Ellis, and Liu only
Answer: C
NEW QUESTION # 139
Which one of the following SAS statements renames two variables?
- A. set work.dept1work.dept2(rename = (jcode = jobcode)(sal = salary));
- B. set work.dept1work.dept2(rename = jcode = jobcodesal = salary);
- C. set work.dept1work.dept2(rename = (jcode jobcode)(sal salary));
- D. set work.dept1work.dept2(rename = (jcode = jobcodesal = salary));
Answer: D
NEW QUESTION # 140
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?
- A. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- B. The output displays only a list of the SAS data sets that are contained in the WORK library.
- C. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.
- D. The output displays only the contents of the SAS data sets that are contained in the WORK library.
Answer: C
NEW QUESTION # 141
By default, which variables and data values are used to calculate statistics in the MEANS procedure?
- A. all non-missing numeric variable values and numbers stored as character variables
- B. all non-missing numeric variable values
- C. all missing and non-missing numeric variable values and numbers stored as character variables.
- D. all missing and non-missing numeric variable values
Answer: B
NEW QUESTION # 142
The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
- A. norowcount nocolcount
- B. freq percent
- C. norow nocol
- D. nocounts
Answer: C
NEW QUESTION # 143
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
- A. 0
- B. No variables are output to the data set as the program fails to execute due to errors
- C. 1
- D. 2
Answer: A
NEW QUESTION # 144
When SAS encounters a data when reading from a raw data file, which action will occur?
- A. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
- B. SAS will write an ERROR message to the SAS log and suspend execution.
- C. SAS will write a WARNING message to the SAS log and suspend execution.
- D. SAS will write a NOTE to the SAS log and continue execution.
Answer: A
NEW QUESTION # 145
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- A. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
- B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
- C. The _ERROR_ variable contains the number of the observation that caused the data error.
- D. The _ERROR_ variable can be used in expressions in the DATA step.
Answer: D
NEW QUESTION # 146
The following SAS program is submitted:
data work.month;
date = put('13mar2000'd,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
- A. numeric, 8 bytes
- B. numeric, 10 bytes
- C. character, 10 bytes
- D. character, 8 bytes
Answer: C
NEW QUESTION # 147
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
- A. MSOFFICE2K
- B. EXCELXP
- C. CSVALL
- D. WINXP
Answer: D
NEW QUESTION # 148
CORRECT TEXT
The following SAS program is submitted:
How many observations are written to the WORK.VOLUME data set?
Enter your numeric answer in the space below.
Answer:
Explanation:
1
NEW QUESTION # 149
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
- style price
- CONDO$79,700
- TWOSTORY$62550
Which DEFINE statement completes the program and produces the desired output?
- A. define style / display width = 9;
- B. define style / width = 9,
- C. define style / group width = 9;
- D. define style / order width = 9;
Answer: C
NEW QUESTION # 150
The following SAS program is submitted:
libname temp 'SAS data library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
- A. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
- B. The program executes successfully and a temporary SAS data set is created.
- C. The program executes successfully and a permanent SAS data set is created.
- D. The program fails execution because the same SAS data set is referenced for both read and write operations.
Answer: C
NEW QUESTION # 151
......
Real A00-231 Quesions Pass Certification Exams Easily: https://www.freecram.com/SASInstitute-certification/A00-231-exam-dumps.html
Practice with these A00-231 dumps Certification Sample Questions: https://drive.google.com/open?id=1hpOa-ZbC9L397HEGAuH3wkBav0TRH2CX