新しい質問 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?

新しい質問 60
正しいテキスト
The following SAS program is submitted:

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

新しい質問 61
What is the purpose or the MISSOVER option on the INFILE statement?

新しい質問 62
The following SAS program is submitted:

What is produced as output?

新しい質問 63
Which ODS statement option terminates output being written to an HTML rile?

新しい質問 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?

新しい質問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?

新しい質問 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?

新しい質問 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?

新しい質問 68
The following SAS program is submitted:

What is the value of the variable var1?

新しい質問 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?

新しい質問 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?

新しい質問 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?

新しい質問 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?

新しい質問 73
Given the SAS data set WORK.THREE:

The following SAS program is submitted:

その結果は？

新しい質問 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:
その結果は？

新しい質問 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?

新しい質問 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?

新しい質問 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?

新しい質問 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?

新しい質問 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?

新しい質問 81
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?