A00-231 Dumps Updated Oct 20, 2023 Practice Test and 265 unique questions
2023 Latest 100% Exam Passing Ratio - A00-231 Dumps PDF
NEW QUESTION # 78
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
- A. Option C
- B. Option D
- C. Option A
- D. Option B
Answer: C
NEW QUESTION # 79
The following SAS program is submitted:
data work.totalsales;
set work.monthlysales(keep = year product sales);
retain monthsales {12} ;
array monthsales {12} ;
do i = 1 to 12;
monthsales{i} = sales;
end;
cnt + 1;
monthsales{cnt} = sales;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
- A. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
- B. The program fails execution due to data errors.
- C. The program fails execution due to syntax errors.
- D. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations
Answer: C
NEW QUESTION # 80
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement.
Which statement regarding this variable is true?
- A. It is assigned a value 0 when the data step begins execution.
- B. It is assigned a value 0 at compile time.
- C. It is assigned a value of missing at compile time.
- D. It is assigned a value of missing when the data step begins execution.
Answer: B
NEW QUESTION # 81
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 Probl.
- B. The value of the DESCRIPTION variable is No Problems.
- C. The value of the DESCRIPTION variable is Problems.
- D. The value of the DESCRIPTION variable can not be determined.
Answer: C
NEW QUESTION # 82
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS informat correctly completes the program?
- A. date9
- B. ddmmyy10
- C. mondayyr10
- D. mmddyy10
Answer: D
NEW QUESTION # 83
A raw data file is listed below:
How many observations will the WORK.HOMEWORK data set contain?
- A. No data set is created as the program fails to execute due to errors.
- B. 0
- C. 1
- D. 2
Answer: D
NEW QUESTION # 84
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 # 85
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
What is output?
- A. Option C
- B. Option A
- C. Option D
- D. Option B
Answer: C
NEW QUESTION # 86
The following SAS program is submitted:
What is the initial value of the variable Total in the following program?
- A. Missing
- B. 0
- C. The value of the first observations Wagerate
- D. Cannot be determined from the information given
Answer: A
NEW QUESTION # 87
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
- A. An incomplete output data set is created due to syntax errors.
- B. PRODUCT, MONTH, NUM_SOLD and COST only
- C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
- D. PRODUCT and SALES only
Answer: A
NEW QUESTION # 88
The following SAS program is submitted:
data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?
- A. .(missing numeric)
- B. 0
- C. 1
- D. 2
Answer: B
NEW QUESTION # 89
Given the following SAS log entry:
What caused the error?
- A. The CANCEL option is required with DATALINES.
- B. Character data must be specified in quotes.
- C. A semi-colon is missing on the DATALINES statement.
- D. The INPUT statement should be after the DATALINES statement.
Answer: C
NEW QUESTION # 90
Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word 'Manager'?
- A. where Job_Title='% Manager ';
- B. where upcase(scan(Job_Title,-1,''))='MANAGER';
- C. where Job_Title like '%Manager%';
- D. where substr(Job_Title,(length(Job_Title)-6))='Manager';
Answer: C
NEW QUESTION # 91
The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
- A. $25.31
- B. .(missing numeric value)
- C. No value is stored as the program fails to execute due to errors.
- D. 25.31
Answer: B
NEW QUESTION # 92
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:
The following program is submitted:
Which statement should be inserted to produce the following output?
- A. Qtr1 = sum(of month{_ALL_});
- B. Qtr1 = month{1} + month{2} + month {3};
- C. Qtr1 = sum(of month {3});
- D. Qtr1 = sum(of month {*});
Answer: D
NEW QUESTION # 93
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A. Option A
- B. Option D
- C. Option C
- D. Option B
Answer: C
NEW QUESTION # 94
Consider the following data step:
The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.
Which statement regarding this program is true?
- A. City's value will be assigned one time, State's value 5 times.
- B. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
- C. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
- D. The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
Answer: A
NEW QUESTION # 95
Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group-1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?
- A. where Age not between (15 and 16) then Group=1;
- B. if Age not in(15,16) then Group=1;
- C. where Age not between 15 and 16 then Group=1;
- D. if (Age NE 16) or (Age NE 15) then Group=1;
Answer: D
NEW QUESTION # 96
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 # 97
......
SASInstitute A00-231 certification exam is an advanced level exam that is designed to test the proficiency of individuals in SAS Base programming. A00-231 exam is performance-based, which means that candidates are required to complete tasks in a simulated SAS environment to demonstrate their knowledge and skills.
Verified A00-231 dumps Q&As - 100% Pass from TestInsides: https://www.testinsides.top/A00-231-dumps-review.html
Pass Exam With Full Sureness - A00-231 Dumps with 265 Questions: https://drive.google.com/open?id=1NA4LSolHteSK0OotSKvr67gYr6HSU2pf