Free A00-231 Exam Braindumps certification guide Q&A
A00-231 Certification Overview Latest A00-231 PDF Dumps
NEW QUESTION # 134
The following SAS program is submitted:
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
Which one of the following is the value of the variable FIRST in the output data set?
- A. Agatha
- B. '' (missing character value)
- C. C
- D. A
Answer: D
NEW QUESTION # 135
Given the following SAS log entry:
What caused the error?
- A. The INPUT statement should be after the DATALINES statement.
- B. Character data must be specified in quotes.
- C. A semi-colon is missing on the DATALINES statement.
- D. The CANCEL option is required with DATALINES.
Answer: C
NEW QUESTION # 136
The following SAS program is submitted:
Which statement is true about the output data set?
- A. The program fails to execute due to errors.
- B. The type of the variable CharEmpid is numeric.
- C. The type of the variable CharEmpid is character.
- D. The type of the variable CharEmpid is unknown.
Answer: A
NEW QUESTION # 137
The following SAS program is submitted once:
Which procedure output will appear in test.html?
- A. No procedure output due to syntax errors
- B. Both the PRINT procedure and FREQ procedure output
- C. Only the PRINT procedure output
- D. Only the FREQ procedure output
Answer: A
NEW QUESTION # 138
This question will ask you to provide a missing format:
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS information correctly completes the program?
- A. ddmmyy10
- B. date9
- C. date10
- D. mmddyy10
Answer: D
NEW QUESTION # 139
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A. .(missing numeric value)
- B. Fail
- C. 50.5
- D. Pass
Answer: C
NEW QUESTION # 140
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 141
Given the contents of the raw data file TYPECOLOR:
----I----10---I----20---I----30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile 'typecolor';
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?
- A. type colordaisy ellow
- B. No values are stored for the TYPE and COLOR variables.
- C. type colordaisyyellow" "(missing character value)
- D. type colordaisygreen
Answer: A
NEW QUESTION # 142
The following SAS program is submitted:
data work. new;
length word $7;
amount = 4;
it amount = 4 then word = 'FOUR';
else if amount = 7
then word = 'SEVEN';
else word = 'NONE!!!';
amount = 7;
run;
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
- A. amount word 7 FOUR
- B. amount word 4 FOUR
- C. amount word 4 NONE!!!
- D. amount word 7 SEVEN
Answer: A
NEW QUESTION # 143
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 # 144
The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.
Which one of the following is the length of the variable JOBCODE in the output data set?
- A. 0
- B. The length can not be determined as the program fails to execute due to errors.
- C. 1
- D. 2
Answer: A
NEW QUESTION # 145
The SAS data set EMPLOYEE_INFO is listed below:
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;
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?
- A. by IDNumber descending Expenses descending;
- B. by descending IDNumber Expenses;
- C. by (IDNumber Expenses) descending;
- D. by descending IDNumber descending Expenses;
Answer: D
NEW QUESTION # 146
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 147
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:
What are the formats of the variables LocalFee and CountryFee in the output data set?
- A. LocalFee has format of 9. and CountryFee has a format of percent7.2
- B. LocalFee has format of 9. and CountryFee has a format of 7.
- C. Both LocalFee and CountryFee have a format of percent7.2
- D. The data step fails execution; there is no format for LocalFee.
Answer: C
NEW QUESTION # 148
What describes the SAS automatic _ERROR_ variable?
- A. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
- B. The _ERROR_ variable contains the values 'TRUE' or 'FALSE.'
- C. The _ERROR variable maintains a count of the number of data errors.
- D. The ERROR_variable contains the number or the observation that caused the error.
Answer: A
NEW QUESTION # 149
The following SAS program is submitted:
If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
- A. SENIOR PILOT
- B. Unknown
- C. '' (missing character value)
- D. Senior Pilot
Answer: B
NEW QUESTION # 150
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
- A. libname sasdata 'SAS-data-library';data sasdata.mydata;copy mydata;run;
- B. libname sasdata 'SAS-data-library';data sasdata.mydata;set mydata;run;
- C. libname sasdata 'SAS-data-library';data sasdata.mydata;save mydata;run;
- D. libname sasdata 'SAS-data-library';data sasdata.mydata;keep mydata;run;
Answer: B
NEW QUESTION # 151
The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?
- A. to the SAS data set _NULL_
- B. to the SAS output window or to an output file
- C. to the raw data file that was most recently opened
- D. to the SAS log
Answer: D
NEW QUESTION # 152
......
The Best SASInstitute A00-231 Study Guides and Dumps of 2023: https://www.prepawaytest.com/SASInstitute/A00-231-practice-exam-dumps.html
Top SASInstitute A00-231 Exam Audio Study Guide! Practice Questions Edition: https://drive.google.com/open?id=1Y6W6w8pFCZNdg8HOz5w1TyRm0jBI-ldg