可能因為題庫換了吧。有很多題都沒見過。 有很多online tutor 上沒有的東東。考了幾道有關(guān)excel import 的問題,比如怎樣導(dǎo)入sheet1
find() catx() 函數(shù)
DATA Step DEBUG
If X<10 Then X=1;
Else If 10<=X<20 Then X=2;
Else X=3;
問題時,如果X是Missing value,那么X結(jié)果是什么?
OUTPUT:題目好多個,例如有一個,
X Y
5 3
1 2
5 6
DATA One Two Other;
SET SASDATA.Two;
If X=5 then output ONE;
If Y LT 5 then output ONE;
Output;
RUN;
Tom, John, Golf, Ball
Ben, Richard
Tracy, Bent, Swim
然后程序是:
infile “ “ dlm=’,’;
Input FNAME $ LNAME $ GAME $ TOOL $;
……
幾個observation?
Pageno
@符號;@@?
Retain Variable
SET TEST (Obs=5);
Retain City = ‘Los Angeles’;
State = ‘California’;
RUN;
Array DIFF{3} Dif-Count1 Dif-Count2 Dif-Count3;
Array PRACTIS{3} Jan Feb Mar;
……
哪個產(chǎn)生了NEW Variable?
1) Dif-Count1 Dif-Count2 Dif-Count3
2) Jan Feb Mar
3) Diff1 Diff2 Diff3
4) PRACTIS1 PRACTIS2 PRACTIS3
偶選的是3
Drop = a b; Keep = a b;修改
1) Keep = (a b);
2) Keep a b;
3) Keep = (a,b);
4) Keep = a, b;
fisrt last 考了好幾題
If First.Department ;
If Last.Department;
……