[Dec 01, 2023] Latest SAS Institute Systems A00-231 Actual Free Exam Questions
SAS Institute Systems A00-231 Dumps Updated Practice Test and 265 unique questions
NEW QUESTION # 62
The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = '1001';
Item_Reference = Item'/'Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
- A. 1001/5461
- B. 1001/ 5461
- C. . (missing numeric value)
- D. The value can not be determined as the program fails to execute due to errors.
Answer: D
NEW QUESTION # 63
The following output is created by the FREQUENCY procedure:
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;
- A. tables region product;
- B. tables region,product
- C. tables region/product;
- D. tables region*product;
Answer: D
NEW QUESTION # 64
Given the raw data file AMOUNT:
----I---- 10---I----20---I----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;
What is the result?
- A. The value of the DESCRIPTION variable is No Problems.
- B. The value of the DESCRIPTION variable is Problems.
- C. The value of the DESCRIPTION variable is No Probl.
- D. The value of the DESCRIPTION variable can not be determined.
Answer: B
NEW QUESTION # 65
The following SAS program is submitted:
Which statement is true about the output data set?
- A. The type of the variable CharEmpid is numeric.
- B. The type of the variable CharEmpid is unknown.
- C. The type of the variable CharEmpid is character.
- D. The program fails to execute due to errors.
Answer: D
NEW QUESTION # 66
The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?
- A. January 1st
- B. 01012000
- C. The value can not be determined as the program fails to execute due to errors
- D. . (missing numeric value)
Answer: C
NEW QUESTION # 67
Given the SAS data set WORK.THREE:
The following SAS program is submitted:
What is the result?
- A. Data set SASUSER.ONE has 2 observations Data set SASUSER.TWO has 2 observations Data set WORK.OTHER has 5 observations
- B. Data set SASUSER.ONE has 2 observations Data set SASUSER.TWO has 2 observations Data set WORK.OTHER has 1 observations
- C. No data sets are output. The DATA step fails execution due to syntax errors.
- D. Data set SASUSER.ONE has 5 observations Data set SASUSER.TWO has 5 observations Data set WORK.OTHER has 3observations
Answer: D
NEW QUESTION # 68
Given the following raw data record:
07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?
- A. date9.
- B. ddMMMyy9.
- C. dmy9.
- D. ddmmmyyyy9.
Answer: A
NEW QUESTION # 69
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
- A. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;
- B. proc print data = sasuser.houses; where price lt 60000 and price gt 100000; run;
- C. proc print data = sasuser.houses; where price lt 60000 or where price gt 100000; run;
- D. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;
Answer: D
NEW QUESTION # 70
Given the data sets below:
WORK.EMP with variables:
WORK.NEWHIRE with variables:
The following SAS program is submitted:
The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.
How many variables will the data set WORK.ALLEMP contain?
- A. 0
- B. 1
- C. 2
- D. The program fails execution.
Answer: B
NEW QUESTION # 71
The contents of the raw data file NAMENUM are listed below:
--------10-------20-------30
Joe xx
The following SAS program is submitted:
data test;
infile 'namenum';
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?
- A. Joe
- B. The value can not be determined as the program fails to execute due to errors.
- C. . (missing numeric value)
- D. xx
Answer: C
NEW QUESTION # 72
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: B
NEW QUESTION # 73
A raw data record is listed below:
--------10-------20-------30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile 'file-specification';
input date $ 1 - 10;
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?
- A. duration = today( ) - input(date,yymmdd10.);
- B. duration = today( ) - put(date,yymmdd10.);
- C. duration = today( ) - put(date,ddmmyy10.);
- D. duration = today( ) - input(date,ddmmyy10.);
Answer: A
NEW QUESTION # 74
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?
- A. 0
- B. 1
- C. 2
- D. (missing numeric value)
Answer: A
NEW QUESTION # 75
The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?
- A. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
- B. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
- C. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
- D. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
Answer: D
NEW QUESTION # 76
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 # 77
A raw data file is listed below:
How many observations will the WORK.HOMEWORK data set contain?
- A. 0
- B. 1
- C. No data set is created as the program fails to execute due to errors.
- D. 2
Answer: B
NEW QUESTION # 78
Which one of the following SAS statements renames two variables?
- A. set work.dept1work.dept2(rename = jcode = jobcodesal = 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 = jobcode)(sal = salary));
Answer: B
NEW QUESTION # 79
Which one of the following SAS procedures displays the data portion of a SAS data set?
- A. CONTENTS
- B. PRINT
- C. FSLIST
- D. DATASETS
Answer: B
NEW QUESTION # 80
The SAS data set BANKS is listed below:
BANKS
name rate
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
The following SAS program is submitted:
data newbank;
do year = 1 to 3;
set banks;
capital + 5000;
end;
run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
- A. 9 observations and 2 variables
- B. 3 observations and 3 variables
- C. 1 observations and 4 variables
- D. 0 observations and 0 variables
Answer: C
NEW QUESTION # 81
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country = City!!', '!!'England';
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
- A. Ipswic h, England
- B. Ipswich, England
- C. Ipswich, 'England'
- D. Ipswich!!
Answer: B
NEW QUESTION # 82
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100); run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500); run;
How many observations are processed by each procedure?
- A. 401 for PROC PRINT4500 for PROC MEANS
- B. 401 for PROC PRINT4501 for PROC MEANS
- C. 400 for PROC PRINT4500 for PROC MEANS
- D. 500 for PROC PRINT5000 for PROC MEANS
Answer: B
NEW QUESTION # 83
......
Verified A00-231 dumps Q&As - 100% Pass from NewPassLeader: https://www.newpassleader.com/SASInstitute/A00-231-exam-preparation-materials.html
Latest 100% Exam Passing Ratio - A00-231 Dumps PDF: https://drive.google.com/open?id=1whiMzVLLa6LoSm4tABjjzylfXbfN2GZr