第一次发帖,感谢大家的机经,94%通过,赞人品,分享一下我考试出现的题目,我一共考62题:70题:
1.(变)gender gender
3. proc print data=MYXLS.'NORTH$'n;run;
5.infile 'customer.txt' obs=10;
6.keep Product Sales;
7. WINXP
9.(变)50.5
10. The value of the variable Discount in the output data set is missing. A note inthe SAS log refers to invalid numeric data
11.proc means data=SASHELP.CLASS min max mean maxdec=1
13. Diff1, Diff2 and Diff3
16. DayOfMonth, Year, and MonthOfYear are numeric
17. Western WesternWestern
18.(变) 前面加了only, 其他不变 The _ERROR_ variable can be used in expressions in the DATA step
19. No output is generated
20. Both LocalFee and CountryFee have a format of percent7.2
21. (变)GT 50 ans:1
22. proc contents data=WORK._all_; run;
24. infile 'file specification' dlm dsd;
27. (变)题目变成day descending month. Day Month Temp
选:
1 May
2 July
3 June
14 July
15 May
15 June
28. WORK.P2000(rename=(Location=State))
30. An execution error, triggered by an invalid character for the variable Salary
31. 选C
32. It is assigned a value 0 at compile time.
33. Unknown
34. in a SAS catalog
35. (变)B: 2 2 1
36. (变) ddmmyy10
37. proc print data=SASUSER.HOUSES label;
label Open_Date="Starting Date";run;
40. 7
42. (变填空) ans:5
43. (变)ANS:PUT(date,worddate20.)
45. (变) Ods csvall file=’c:\test.cvs’;
Ods csvall close;
46. 1.6
48. 原题,选A
51. (变)选list....metadata
52.(变)WORK.EMP_NAME:多加了一行数据,答案:3
56. tables region*product
57. (变)题目出现day of month, 答案:ANS:day(BeginDate)
58. The format name contains a period in the VALUE statement
60.(变)drop 少了一个 ans:3
61. if Age not in(15,16) then Group=1; else Group=2
62.(变) ods pdf file='sales.pdf'; ods pdf close;
63. 7
65. The label of the variable Jobcode is Job Description
66. output ans:5
67.(变) X < 10 then X=3, 选:X would get a value of 3
69. where Job_Title like '%Manager%'
95题:
93:ANS: sum(of month{*})
123题:
11.(变) eof=1
7. missing numeric value
27. ans:14
50. 填空:by IDnumber Expenses
64. 题目变,上面有说length=8, ans:8
88. 原体
104. 50.5
108. unknown
110. 22
新题:命名題 Q:哪2個命名才是正確的?
2TEST
2-TEST
_TEST
TEST_
ANS: 2個 (_TEST 和TEST_)
其他新题:
1. Split‘*’
2. 2060
3. Put(date,worddate20.)
4. doyear 2012 to 2021 和output(我选错了,选了2012-2021, 应该是2012 to 2021 和output)
5. ans: The semi-column missing on dataline
6. Toys Indoors (7chars)
Drums Instrum (7 chars)
Recorder Instrum(7chars)
Ball Outdoor(7chars)
7. descendingoption only applies on date
最后谢谢大家的分享,今天好好休息一天,明天开始advance的学习,大家加油~~~