上午跑去考的 考完了还要去上班 趁着我还记得赶紧传上来~~
共62道题 2道填空
70/95题库
3 5 10 11 13(选 Diff1, Diff2, Diff3) 15
16 17 20 21(变形 GT50)22 24 28
30 31 32 33 (“ALBUM”,答案不变)
35( 加了条件, if Y lt 5 then outputSASDATA.TWO; else output OTHERS. 选B)
36 数据改为 19 2 2004, 选ddmmyy10.
37
42变形. 填空题 Text=‘US-Australia-Denmark'
Pos=find(Text, US,'i',5)
问pos的输出值
45 46 51 52 (多了个EmpID, 选3) 56
57.
N Begindate Day
1 09Jan2010 9
2 12Jan2010 12
选day(Begindate)
61 62(html 改为pdf). 63.
66 填空题 do year= 1 to 7;
Do month=1 to 12;
X+1;
End;
Output;
End;
问x的输出值是_____
67 if X<10 then X=3, 选3
69 原题
71 (有变动,选项为:2Test, 2Test_, _Test2, Test2 选2)
93
##附上 第9题 Crakman上的
data course;
input exam;
datalines;
50.1
;
run;
proc format;
value score 1 – 50 = \’Fail\’
51 – 100 = \’Pass\';
run;
proc report data =course nowd;
column exam;
define exam / displayformat=score.;
run;
What is the value for exam?
A. Fail
B. Pass
C. 50.1
D. No output
Answer: C
123题库
5 11 27 52
88 94 101 104
110(数据有变化,Ruth 39 11 Jose 22 33 ; ) 选33
历史机经
#split='*'
#Datalines 缺分号
5. 考yearcutoff
options yearcutoff=1920;
data work.one;
dateA='01JAN19'd;
yearA=year(dateA);
dateB='01JAN20'd;
yearB=year(dateB);
diff=yearB- yearA;
run;
问diff等于几,答案
-99
# population increase: do 2012 to 2021, end前有output
# N和_Error_: 确认选N=1234 _Error_=1001 (因为最后一个variable定义的格式问题 只有第一个和最后一个obs涉及到最后一栏的variable)
# odshtml;
proc freq...;
proc print; run;
ods html close; (确认选Both;两个都会output)
If _N_=1 then total=0; Else total=A+B; 就看最后一列total的值, 第一个obs是0,剩下的是A+B之和, 0,32, 35
输出csv文件 选odscsvall..(这道题错了o(╯□╰)o)
Sort by 问题 Descending Date Only
问proc means可以处理的数据是什么,选项有
nonmissing numbers
missing and nonmissing numbers
nonmissing numbers and numbers in character form
missing and nonmissing numbers and numbers in characterform
新题:
给出Date Amount
01Mar2010 20
02Mar2010 15
03Mar2010 .
04Mar2010 35
05Mar2010 40
Data…..;
Set TOTAL;
Total= Total+ Amount;
Output;
Run;
问最后输出的dataset
A.
Date Amount Total
01Mar2010 20 20
02Mar2010 15 35
03Mar2010 . .
04Mar2010 35 70
05Mar2010 40 110
B.
Date Amount Total
01Mar2010 20 .
02Mar2010 15 .
03Mar2010 . .
04Mar2010 35 .
05Mar2010 40 .
C.
Date Amount Total
01Mar2010 20 20
02Mar2010 15 15
03Mar2010 . .
04Mar2010 35 35
05Mar2010 40 40
D.
Date Amount Total
01Mar2010 20 20
02Mar2010 15 35
03Mar2010 . .
04Mar2010 35 .
05Mar2010 40 .
我想着应该是Total statement中missing value的考点,选的A
****大家好多都是像我一样 荷包憋憋的。。。就免费奉上,攒人品 要是大家赏个论坛币就更好了 准备过一个月再考Adv~~~ 大家加油哦~~~~****
欢迎光临 CFA论坛 (http://forum.theanalystspace.com/) | Powered by Discuz! 7.2 |