[Q96-Q112] Best Quality A00-231 Exam Questions SASInstitute Test To Gain Brilliante Result!

NEW QUESTION 96
The following SAS program is submitted:
proc format
value score 1 – 50 = ‘Fail’
51 – 100 = ‘Pass’;
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

NEW QUESTION 97
The following SAS program is submitted:
libname temp ‘SAS-data-library’;
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?

NEW QUESTION 98
This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?

NEW QUESTION 99
The following SAS DATA step is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5.
Which one of the following is the length of the variable JOBCODE in the output data set?

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

What changes should be made to the KEEP statement to correct the errors in the LOG?

NEW QUESTION 101
The following SAS program is submitted:
libname rawdata1 ‘location of SAS data library’;
filename rawdata2 ‘location of raw data file’;
data work.testdata;
infile
input sales1 sales2;
run;
Which one of the following is needed to complete the program correctly?

NEW QUESTION 102
The following SAS program is submitted:

What will the data set WORK.TEST contain?

NEW QUESTION 103
The following SAS program is submitted:
data work.test;
array agents{4} $ 12 sales1 – sales4;
run;
Which one of the following represents the variables that are contained in the output data set?

NEW QUESTION 104
Given the SAS data set WORK.ONE:

What value will SAS assign to Total?

NEW QUESTION 105
Which one of the following SAS procedures displays the data portion of a SAS data set?

NEW QUESTION 106
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?

NEW QUESTION 107
Given the contents of the raw data file TYPECOLOR:
—-I—-10—I—-20—I—-30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile ‘typecolor’;
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?

NEW QUESTION 108
The following SAS program is submitted:
libname sasdata ‘SAS-data-library’;
data test;
set sasdata.chemists (keep = job_code);
if job_code = ‘chem3’
then description = ‘Senior Chemist’;
run;
The variable JOB_CODE is a character variable with a length of 6 bytes.
Which one of the following is the length of the variable DESCRIPTION in the output data set?

NEW QUESTION 109
The following SAS program is submitted:

What is the value of the second variable in the data set WORK.AUTHORS?

NEW QUESTION 110
The following SAS program is submitted:
data WORK.DATE_INFO;
X=”01Jan1960″ D;
run;
What variable X contains what value?

NEW QUESTION 111
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.; The following SAS program is submitted:
data history;
format local fee country fee percent6.;
set realestate;
local fee = local fee / 100;
country fee = country fee / 100;
run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

NEW QUESTION 112
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?