大概考了這些題
70
1.gender gender
3.
5
7
9.50.5 也是123里面的104
10
11
13 diff1 diff2 diff3
16
17
18_ERROR_ can only be used in expressions in the DATA step.
19
20
21 gt=50 答案1
22
24
27 by Day descending Month;選Day 是1, 2, 3, 。。。。的
36 raw data改了,dataset里面日期在前面,選ddmmyy10
37
42 題目Text=’US,Australia,Denmark’; Pos=find(Text,’US’,’i’,5); 填5
43 put (ship_date,worddate20.)
46 多了個(gè)變量Revenue 2007,其值為缺失值,答案不變。 mean求和自動(dòng)忽略所以答案還是1.6
51答案里多了個(gè)名詞metadata. both list and metadata
52WORK.EMP_NAME 里多了一個(gè)observation 答案是3
56
57題目改成求一個(gè)月當(dāng)中的第幾天,day數(shù)據(jù)變成一個(gè)12一個(gè)9 選day(BeginDate).
58
60第一行只drop了兩個(gè)變量(Sales Returns)。少drop了一個(gè) 答案變?yōu)?
61
62 pdf
63
65
66do Year=1 to 5; do Month=1 to 12; X+1;end后面加了output; end;答案5.
67 3
69
95
71
93
123
7
11
27
50
94
109
118
新題考的很多:
Name Character Length 8
Date Numeric Length 8
StartDate Numeric length 8
data two;
set one;
length Name $ 10;
format Name $20. Date StartDate Date9.;
run;
問 the length of NameEndFragment 答案是8
dataline后面少分號(hào)
If product=”Toys” then Description=”Indoors”;
Else if product=in(“Drums”,”Recorder”) then Description=”Instrument”;
Else if product=”Ball” then Description=”O(jiān)utdoors”;
問OUTPUT, 答案:
Product Description
Toys Indoors
Drums Instrum
Recorder Instrum
Ball Outdoor
Date Amount
01Mar2010 20
02Mar2010 15
03Mar2010 .
04Mar2010 35
05Mar2010 40
Data…..;
Set TOTAL;
Total= Total+ Amount;
Output;
Run;
問輸出dataset,選:
Date Amount Total
01Mar2010 20 .
02Mar2010 15 .
03Mar2010 . .
04Mar2010 35 .
05Mar2010 40 .
do year=2012 to 2021;
population*1.02;
output;
end;
wrap label怎么換行 split='*' .