Get Real A00-231 Quesions Pass SASInstitute Certification Exams Easily
A00-231 Dumps are Available for Instant Access
NEW QUESTION # 98
The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
- A. The variable Code is sorted by ascending order.
- B. The descending option applies to the Date and Cost variables.
- C. The descending option applies to the variable Code.
- D. The PSORT data set is stored in the SASUSER library.
Answer: A
NEW QUESTION # 99
Given the SAS data set WORK.ORDERS:
Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?
- A. Ship_date_char = input(Ship_date,worddate20.);
- B. Ship_date_char = input(Ship_date, date9.,worddate20.);
- C. Ship_date_char = put(Ship_date,worddate20.);
- D. Ship_date_char = put(Ship_date, date9.,worddate20.);
Answer: C
NEW QUESTION # 100
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?
- A. proc print data=MYXLS.'NORTH$'n;run;
- B. proc print data=MYXLS.NORTH;run;
- C. proc print data=MYXLS.'NORTH'e;run;
- D. proc print data=MYXLS.NORTH$;run;
Answer: A
NEW QUESTION # 101
The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?
- A. Dickens
- B. T
- C. '' (missing character value)
- D. of
Answer: C
NEW QUESTION # 102
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
- A. 0
- B. 1
- C. . (missing numeric value)
- D. The program fails to execute due to errors.
Answer: B
NEW QUESTION # 103
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',transwrd(ship_date,date9.));
- B. note=catx('','Order',order_id,'shipped on',char(ship_date,date9.));
- C. note=catx('','Order',order_id,'shipped on',put(ship_date,date9.));
- D. note=catx('','Order',order_id,'shipped on',input(ship_date,date9.));
Answer: C
NEW QUESTION # 104
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?
- A. the character value "01011960"
- B. the numeric value 0
- C. a missing value due to syntax errors
- D. the step will not compile because of the character argument in the mdy function.
Answer: B
NEW QUESTION # 105
The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1;
end;
run;
Which one of the following is the value of the variable N in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 106
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 / order width = 9;
- D. define style / group width = 9;
Answer: D
NEW QUESTION # 107
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?
- A. do i = 1 to 5;
- B. do i = mon tue wed thu fri;
- C. A DO loop cannot be used because the variables referenced do not end in a digit.
- D. do weekly{i} = 1 to 5;
Answer: A
NEW QUESTION # 108
The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:
What is the length of the Name variable in the data set WORK STAFF_UPDATE?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 109
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?
- A. : (colon)
- B. , (comma)
- C. ; (semicolon)
- D. (space)
Answer: D
NEW QUESTION # 110
Which one of the following SAS system options prevents the page number from appearing on a report?
- A. NOPAGE
- B. NONUMBER
- C. NONUM
- D. NOPAGENUM
Answer: B
NEW QUESTION # 111
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: D
NEW QUESTION # 112
The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
- A. MONTHLY1, MONTHLY2 and MONTHLY3
- B. JANSALES, FEBSALES and MARSALES
- C. DIFSALES1, DIFSALES2 and DIFSALES3
- D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
Answer: C
NEW QUESTION # 113
......
Get Instant Access REAL A00-231 DUMP Pass Your Exam Easily: https://www.free4torrent.com/A00-231-braindumps-torrent.html
Practice with these A00-231 dumps Certification Sample Questions: https://drive.google.com/open?id=1nB7LeY81zrz4lmIHoEnhZ_koqYiWRPGt