SAS认证新题型ADVANCE

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 EMPLOYEE.Name=(select Names delimited with ',' from WORK.NEWEMPLOYEE

where Salary > 40000);

B.

Replace line 104 with:

where EMPLOYEE.Name =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 \ 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,

本文来源：https://www.bwwdw.com/article/rhbd.html