63真题SAS ADVANCE新题型
时间：2026-01-19
Item 1 of 63 Mark item for review
When attempting to minimize memory usage, the
most efficient way to do group processing when
using the MEANS procedure is to use:
A.
the BY statement.
B.
GROUPBY with the NOTSORTED specification.
C.
the CLASS statement.
D.
multiple WHERE statements.
Item 2 of 63 Mark item for review
The SAS data set WORK.CHECK has a variable
named Id_Code in it. Which SQL statement would
create an index on this variable?
A.
create index Id_Code on WORK.CHECK;
B.
create index(Id_Code) on WORK.CHECK;
C.
make index=Id_Code from WORK.CHECK;
D.
define index(Id_Code) in WORK.CHECK;
Item 3 of 63 Mark item for review
Given the SAS data sets:
WORK.EMPLOYEE WORK.NEWEMPLOYEE
Name Dept Names Salary
-------- ----- -------- ------
Alan Sales Michelle 50000
Michelle Sales Paresh 60000
A SAS program is submitted and
the following is written to the SAS log:
101 proc sql;
102 select dept, name
103 from WORK.EMPLOYEE
104 where name=(select names
from newemployee
where salary > 40000)
ERROR: Subquery evaluated to more than one row.
105 ;
106 quit;
What would allow the program to
successfully execute without errors?
A.
Replace the where clause with:
where http://=(select Names delimited with ','
from WORK.NEWEMPLOYEE
where Salary > 40000);
B.
Replace line 104 with:
where http:// =ANY (select Names separated with ',' from WORK.NEWEMPLOYEE
where Salary > 40000);
C.
Replace the equal sign with the IN operator.
D.
Qualify the column names with the table names.
Item 4 of 63 Mark item for review
Given the SAS data set SASUSER.HIGHWAY:
Steering Seatbelt Speed Status Count
-------- -------- ----- ------- -----
absent No 0-29 serious 31
absent No 0-29 not 1419
absent No 30-49 serious 191
absent no 30-49 not 2004
absent no 50+ serious 216
The following SAS program is submitted:
proc sql noprint;
select distinct
Speed [_insert_SQL_clause_]
from SASUSER.HIGHWAY
;
quit;
title1 "Speed values represented are: &GROUPS";
proc print data=SASUSER.HIGHWAY;
run;
Which SQL clause stores the text 0-29,30-49,50+ in
the macro variable GROUPS?
A.
into &GROUPS
B.
into :GROUPS
C.
into :GROUPS separated by ','
D.
into &GROUPS separated by ','
Item 5 of 63 Mark item for review
The SAS data set WORK.CHECK has an index
on the variable Code and the following SAS
program is submitted.
proc sort data=WORK.CHECK;
by Code;
run;
Which describes the result of submitting
the SAS program?
A.
The index on Code is deleted.
B.
The index on Code is updated.
C.
The index on Code is uneffected.
D.
The sort does not execute.
Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average
salary based on jobcode:
Jobcode Salary Avg
------- ------ -----
PT1 50000 60000
PT1 70000 60000
PT1 60000 60000
PT2 80000 85000
PT2 90000 85000
PT3 100000 100000
Which SQL statement could NOT generate
this result?
A.
select
Jobcode,
Salary,
avg(Salary) label='Avg'
from WORK.PILOTS
group by Jobcode
order by Id
;
B.
select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS as P1
where P1.Jobcode=P2.Jobcode) as Avg
from WORK.PILOTS as P2
order by Id
;
C.
select
Jobcode,
Salary,
(select avg(Salary)
from WORK.PILOTS
group by Jobcode) as Avg
from WORK.PILOTS
order by Id
;
D.
select
Jobcode,
Salary,
Avg
from
WORK.PILOTS,
(select
Jobcode as Jc,
avg(Salary) as Avg
from WORK.PILOTS
group by 1)
where Jobcode=Jc
order by Id
;
Item 7 of 63 Mark item for review
A quick rule of thumb for the space
required to run PROC SORT is:
A.
two times the size of the SAS data set being sorted.
B.
three times the size of the SAS data set being sorted.
C.
four times the size of the SAS data set being sorted.
D.
five times the size of the SAS data set being sorted.
Item 8 of 63 Mark item for review
Multi-threaded processing for PROC SORT will
effect which of these system resources?
A.
CPU time will de …… 此处隐藏：6735字，全部文档内容请下载后查看。喜欢就下载吧 ……
63真题SAS ADVANCE新题型.doc
将本文的Word文档下载到电脑
