首页  /  试题详情

单选题 The following SAS program is submitted:
Data WORK.TEMP;
length A B 3 X;
infile RAWDATA;
input A B X;
Run;
What is the length of variable A?

A、 3
B、 8
C、 WORK.TEMP is not created – X has an invalid length.
D、 Unknown.
查看答案
下载APP答题
由4l***uo提供 分享 举报 纠错
相关题库推荐
SAS advance
2024-08-13
共30道

相关试题

单选题 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.

单选题 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.

单选题 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.

单选题 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
;

单选题 与 QUESTION 16 采用类似数据集。
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 ','
E、 into GROUPS separated by ','
F、 into Groups delimited by ','
G、 into :Groups delimited by ','

单选题 Multi-threaded processing for PROC SORT will affect which of these system resources?

A、 CPU time will decrease, wall clock time will decrease.
B、 CPU time will increase, wall clock time will decrease.
C、 CPU time will decrease, wall clock time will increase.
D、 CPU time will increase, wall clock time will increase.

单选题 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;

单选题 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.