大概考了这些题
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 多了个变量Revenue 2007,其值为缺失值,答案不变。 mean求和自动忽略所以答案还是1.6
51答案里多了个名词metadata. both list and metadata
52WORK.EMP_NAME 里多了一个observation 答案是3
56
57题目改成求一个月当中的第几天,day数据变成一个12一个9 选day(BeginDate).
58
60第一行只drop了两个变量(Sales Returns)。少drop了一个 答案变为3
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后面少分号
If product=”Toys” then Description=”Indoors”;
Else if product=in(“Drums”,”Recorder”) then Description=”Instrument”;
Else if product=”Ball” then Description=”Outdoors”;
问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='*' .