A00-231試験無料問題集「SASInstitute SAS 9.4 Base Programming - Performance-based 認定」

ページ: 1 / 15
トータル 298 問
完全版を入手する
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?

Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

Scenario:
This project will use data set cert.input27. At any time, you may
save your program as program27 in cert\programs. You will use
this program in the next project.
Write a SAS program that will:
* Create output data set results.output27a as a subset
of cert.input27 where the country variable's value is
"US" (any variation of case, such as US or us).
* Sort results.output27a:
" first by the variable state in ascending order
" then by Postal_Code in descending order
" and finally by employee_ID in ascending order.
Run the program and use the results to answer the question below.
What is the value of Employee_ID for observation 100 in results.output27a?
正解：
120781
Explanation:
proc sort data=cert.input27
out=results.output27a(where=(upcase (country)='US'));
by state descending Postal_Code employee_ID;
run;
proc print data=results.output27a (firstobs=100 obs=100);
var employee_ID;
run:
The following SAS program is submitted:
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Which one of the following is the value of the DATE variable?

Which of the following programs correctly invokes the DATA Step Debugger?

The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?

This question will ask you to provide a missing format:
Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS information correctly completes the program?

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?

Given the SAS data set WORK.ONE:

The following SAS program is submitted:

What value will SAS assign to Total?

A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then input sqfeet bedrooms baths street $ price : dollar10.; run; How many observations does the WORK.CONDO_RANCH data set contain?

The Excel workbook REGIONS.XLSX contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS XLSX 'c:\ data\ regions.xlsx';
Which PROC PRINT step correctly displays the NORTH worksheet?

The following SAS program is submitted:
footnote1 'Sales Report for Last Month';
footnote2 'Selected Products Only';
footnote3 'All Regions';
footnote4 'All Figures in Thousands of Dollars'; proc print data = sasuser.shoes; footnote2 'All Products'; run; Which footnote(s) is/are displayed in the report?

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?

Given the SAS data set WORK.PRODUCTS:

How many variables does the WORK.REVENUE data set contain?

The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?

A user-defined format has been created using the FORMAT procedure. Where is it stored?

The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?

This question will ask you to provide a segment of missing code.
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

Which expression successfully completed the program and creates the variable Day?

Read the table

The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:

Which TABLES statement(s) completed the program and produced the output?

The following SAS program is submitted:


Why does the program produce an error? Select one:

ページ: 1 / 15
トータル 298 問