NEW QUESTION 59
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?

NEW QUESTION 60
CORRECT TEXT
The following SAS program is submitted:

What value will SAS assign to Pos? Enter your numeric answer in the space below.

NEW QUESTION 61
What is the purpose or the MISSOVER option on the INFILE statement?

NEW QUESTION 62
The following SAS program is submitted:

What is produced as output?

NEW QUESTION 63
Which ODS statement option terminates output being written to an HTML rile?

NEW QUESTION 64
The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

NEW QUESTION 65
The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

NEW QUESTION 66
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?

NEW QUESTION 67
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 68
The following SAS program is submitted:

What is the value of the variable var1?

NEW QUESTION 69
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?

NEW QUESTION 70
The contents of the raw data file SIZE are listed below:
——–10——-20——-30
72 95
The following SAS program is submitted:
data test;
infile ‘size’;
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?

NEW QUESTION 71
The following SAS program is submitted:
data work. new;
length word $7;
amount = 4;
it amount = 4 then word = ‘FOUR’;
else if amount = 7
then word = ‘SEVEN’;
else word = ‘NONE!!!’;
amount = 7;
run;
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

NEW QUESTION 72
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

NEW QUESTION 73
Given the SAS data set WORK.THREE:

The following SAS program is submitted:

What is the result?

NEW QUESTION 74
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?

NEW QUESTION 75
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 76
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?

NEW QUESTION 77
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS
NAME AGE
Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm ‘SAS data library’;
data students;
set perm. Students;
file ‘file specification’;
put name $15. @5 age 2.;
run;
What is written to the output raw data file?

NEW QUESTION 78
The following SAS program is submitted:
data combine;
prefix=’505′;
middle=’6465 ‘;
end=’09090′;
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

NEW QUESTION 79
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?

NEW QUESTION 80
The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?

NEW QUESTION 81
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?