Free Cram & Latest Exams Dumps

NO.43 Given the SAS data set WORK.THREE:

The following SAS program is submitted:

What is the result?

NO.44 The following SAS program is submitted:
data test;
set chemists;
jobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
————-
chem2
What is the value of the variable DESCRIPTION?

NO.45 This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?

NO.46 Given the SAS data set WORK.P2000:

And the SAS data set WORK.P2008:

The following output is desired:

Which SAS program correctly combines the data?

NO.47 The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?

NO.48 The following SAS program is submitted:
data work.month;
date = input(’13mar2000′,date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?

NO.49 The following SAS program is submitted:

What new variables are created?

NO.50 The following program is submitted:

Why does the program fail?

NO.51 Given the SAS data set ONE:
ONE
ObsDte
————-
109JAN2005
212JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:
TWO
ObsDteDay
109JAN20051
12JAN20054
Which expression successfully completed the program and created the variable DAY?

NO.52 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?

NO.53 The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

NO.54 Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of “James Stevens” for the variableFullName?

NO.55 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?

NO.56 The following SAS program is submitted:
data work.test;
Author = ‘Agatha Christie’;
First = substr(scan(author,1,’ ,’),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?

NO.57 The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?

NO.58 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?

NO.59 The following SAS program is submitted:

What new value would be assigned to X if its original value was a missing value?

NO.60 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?

NO.61 The following SAS program is submitted:

Which statement is true about the output data set?