New 2023 A00-231 Dumps for SAS Institute Systems Certified Exam Questions and Answer
Realistic Verified A00-231 exam dumps Q&As - A00-231 Free Update
NEW QUESTION # 42
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
- A. ods html file = 'sales.html'; ods html close;
- B. ods file html = 'sales.html'; ods file close;
- C. ods html = 'sales.html'; ods html close;
- D. ods file = 'sales.html'; ods file close;
Answer: A
NEW QUESTION # 43
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
- A. weekday(BeginDate)
- B. dayofweek(BeginDate)
- C. getday(BeginDate,today())
- D. day(BeginDate)
Answer: A
NEW QUESTION # 44
The following SAS DATA step executes on Monday, April 25, 2000:
data newstaff;
set staff;
start_date = today();
run;
Which one of the following is the value of the variable START_DATE in the output data set?
- A. the numeric value 14725, representing the SAS date for April 25, 2000
- B. the numeric value 04252000, representing the SAS date for April 25, 2000
- C. a character string with the value '04/25/2000'
- D. a character string with the value 'Monday, April 25, 2000'
Answer: A
NEW QUESTION # 45
A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then input sqfeet bedrooms baths street $ price : dollar10.; run; How many observations does the WORK.CONDO_RANCH data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 46
Which one of the following is true of the SUM statement in a SAS DATA step program?
- A. It is not valid with the SET, MERGE and UPDATE statements.
- B. It adds the value of an expression to an accumulator variable and ignores missing values.
- C. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
- D. It is only valid in conjunction with a SUM function.
Answer: B
NEW QUESTION # 47
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?
- A. The program fails to execute because there are no variables listed on the ARRAY statement.
- B. ITEMS
- C. ITEMS1, ITEMS2, ITEMS3
- D. No variables are created because it is a temporary array.
Answer: D
NEW QUESTION # 48
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. . (missing numeric value)
- C. The value can not be determined as the program fails to execute due to errors.
- D. 1001/ 5461
Answer: C
NEW QUESTION # 49
The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
- A. The descending option applies only to the Code variable.
- B. The descending option applies to the Date and Cost variables.
- C. The descending option applies to the Product and Code variables.
- D. The descending option applies only to the Date variable.
Answer: B
NEW QUESTION # 50
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 YYZ 82174
- B. destination revenue FRA 62129
- C. destination revenue YYZ 53634
- D. destination revenue FRA 75962
Answer: D
NEW QUESTION # 51
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS informat correctly completes the program?
- A. mmddyy10
- B. date9
- C. ddmmyy10
- D. mondayyr10
Answer: A
NEW QUESTION # 52
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A. 50.5
- B. Pass
- C. Fail
- D. .(missing numeric value)
Answer: A
NEW QUESTION # 53
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = 'Jan' then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
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: A
NEW QUESTION # 54
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
- B. The output displays only the metadata of the SAS data sets that are contained in the WORK library.
- C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- D. The output displays only a list of the SAS data sets that are contained in the WORK library.
Answer: A
NEW QUESTION # 55
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
- A. WINXP
- B. MSOFFICE2K
- C. EXCELXP
- D. CSVALL
Answer: A
NEW QUESTION # 56
Given the SAS data set WORK.ONE:
What value will SAS assign to Total?
- A. The program fails to execute due to errors.
- B. 1.6
- C. 4.8
- D. 0
Answer: B
NEW QUESTION # 57
The following SAS program is submitted:
data one;
addressl = '214 London Way';
run;
data one;
set one;
address = tranwrd(address1, 'Way', 'Drive'); run;
What are the length and value of the variable ADDRESS?
- A. Length is 16; value is '214 London Drive'.
- B. Length is 14; value is '214 London Way'.
- C. Length is 200; value is '214 London Drive'.
- D. Length is 14; value is '214 London Dri'.
Answer: C
NEW QUESTION # 58
The following SAS program is submitted:
What is the value of the variable Diff?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 59
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A. Option C
- B. Option B
- C. Option A
- D. Option D
Answer: A
NEW QUESTION # 60
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?
- A. note=catx('','Order',order_id,'shipped on',char(ship_date,date9.));
- B. note=catx('','Order',order_id,'shipped on',input(ship_date,date9.));
- C. note=catx('','Order',order_id,'shipped on',transwrd(ship_date,date9.));
- D. note=catx('','Order',order_id,'shipped on',put(ship_date,date9.));
Answer: D
NEW QUESTION # 61
......
Use Real A00-231 Dumps - 100% Free A00-231 Exam Dumps: https://vcetorrent.examtorrent.com/A00-231-prep4sure-dumps.html
