s*********y
发帖数: 34 | 1 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?
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
;
Why B is not right?
Item 11 of 63 Mark item for review
The following SAS code is submitted:
data WORK.TEMP WORK.ERRORS / view=WORK.TEMP;
infile RAWDATA;
input Xa Xb Xc;
if Xa=. then output WORK.ERRORS;
else output WORK.TEMP;
run;
Which of the following is true of the WORK.ERRORS data set?
A. The data set is created when the DATA step is submitted.
B. The data set is created when the view TEMP is used in another
SAS step.
C. The data set is not created because the DATA statement contains
a syntax error.
D. The descriptor portion of WORK.ERRORS is created when the DATA
step is submitted.
为什么选C
The following program is submitted to check the variables Xa, Xb, and Xc
in the SASUSER.LOOK data set:
data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
set SASUSER.LOOK(keep=Xa Xb Xc);
length _Check_ $ 10 ;
if Xa=. then _check_=trim(_Check_)!!" Xa" ;
if Xb=. then _check_=trim(_Check_)!!" Xb" ;
if Xc=. then _check_=trim(_Check_)!!" Xc" ;
put Xa= Xb= Xc= _check_= ;
run ;
When is the PUT statement executed?
A. when the code is submitted
B. only when the WORK.BAD_DATA view is used
C. both when the code is submitted and the view is used
D. never, the use of _null_ in a view is a syntax error
为什么选B
Item 20 of 63 Mark item for review :
data WORK.TEMP;
length A B 3 X;
infile rawdata;
input A B X;
run;
what's the length of variable A?
A 3; B 8;C work.temp is not created-X has an invalid length; D Unkown
为什么选A? length A B 3 X 着一行不对,不应该有X.
The following program is submitted to check the variables Xa, Xb, and Xc
in the SASUSER.LOOK data set:
data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
set SASUSER.LOOK(keep=Xa Xb Xc);
length _Check_ $ 10 ;
if Xa=. then _check_=trim(_Check_)!!" Xa" ;
if Xb=. then _check_=trim(_Check_)!!" Xb" ;
if Xc=. then _check_=trim(_Check_)!!" Xc" ;
put Xa= Xb= Xc= _check_= ;
run ;
When is the PUT statement executed?
A. when the code is submitted
B. only when the WORK.BAD_DATA view is used
C. both when the code is submitted and the view is used
D. never, the use of _null_ in a view is a syntax error
为什么选B?
|
|
