SASInstitute SAS 9.4 Base Programming - Performance-based - A00-231 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

After a SAS program is submitted, the following is written to the SAS log:

What issue generated the error in the log?

A. A drop statement and a keep= data set option cannot both be used at the same time. B. The syntax of the drop statement does not use an equals sign. C. The list of variables should have been enclosed in parentheses. D. There should have been commas between the variable names.

Discussion 0

Correct Answer: A Vote an answer

Question 2

What is the format for the variableNamein the data setBoth? Select one:

A. $CHAR B. $CHAR15 C. no format defined D. $CHAR10

Discussion 0

Correct Answer: B Vote an answer

Question 3

The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?

A. The BY statement in the DATA step causes a syntax error. B. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set. C. The statement payroll + wagerate; in the DATA step causes a syntax error. D. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

Discussion 0

Correct Answer: D Vote an answer

Question 4

The following SAS program is submitted:
data test;
infile 'file specification';
input name $ amount@@;
run;
Which of the following is true?

A. Two @@ are invalid syntax and will cause the program to fail to execute. B. Two @@ together are the same as one c. C. Two @@ hold the data records until the bottom of the DATA step. D. Two @@ hold the raw data record across iterations of the DATA step.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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;

Discussion 0

Correct Answer: D Vote an answer

Question 6

Given the raw data file EMPLOYEE.TXT:

The following SAS program is submitted:

What value does the variable idnum contain when the name of the employee is "Ruth"?

A. 22 B. 44 C. 33 D. 39

Discussion 0

Correct Answer: A Vote an answer

Question 7

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. 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. B. City's value will be assigned one time, State's value 5 times. C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted. D. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

Discussion 0

Correct Answer: B Vote an answer

Question 8

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?

A. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable. B. The data set WORK.TEST is stored in descending order by values of the NAME variable. C. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable. D. The data set WORK.TEST is stored in ascending order by values of the NAME variable.

Discussion 0

Correct Answer: A Vote an answer

Question 9

The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId.
Which statement is true about the output dataset?

A. The type of the variable CharEmpid is unknown. B. The type of the variable CharEmpid is character. C. The type of the variable CharEmpid is numeric. D. The program fails to execute due to errors.

Discussion 0

Correct Answer: D Vote an answer

Question 10

Which step displays a listing of all the data sets in the WORK library?

A. proc contents lib=WORK.all;run; B. proc contents lib=WORKrun; C. proc contents data=WORK _ALL_;run; D. proc contents data=WORK._all_;run;

Discussion 0

Correct Answer: D Vote an answer

Question 11

Scenario:
Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram48incert\programs. This program is intended to:
* Create 3 groups for C var: A-G is Group=1; H-N is Group=2; O-Z is Group=3.
* All variations of the variable should be in the same group, i.e. "A" and "a" should be in Group=1.
* Calculate the average of X and Y by Group. There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results to answer the next 2 questions. What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number. Enter your numeric answer in the space below:

Discussion 0

Correct Answer:

47