ADV_HQ-JJ_by_mikeleung110_updated_by_MZX_27Jan2018.docx

ADV_HQ-JJ_by_mikeleung110_updated_by_MZX_27Jan2018.docx -...

This preview shows page 1 - 4 out of 14 pages.

SAS ADVANCED 質素機經 by mikeleung110 updated 27 . Jan .201 8 by_MZX 請留意,這並不是最強的機經,我想說這個世界永遠沒有最強的,只有更好更高質素的機經,我在此希望所有享 用及讀過這機經的朋友,希望你們參考之時能再把我這個機經不斷不斷的改善加強,我更加想將這些機經和 LEGENDS 發揚光大,把分享機經的精神宣揚出去,使得日後使用的朋友在學習上更加事半功倍! 內容主要有四大部分: Contents 1. 變題機經 .......................................................................................................................................................... 3 2. 填空題 .............................................................................................................................................................. 6 3. 新題庫 .............................................................................................................................................................. 8 机经题目数量: 1.63 题中的 53 道考过的题; 2. 填空题 9 道; 3. 新题 29 道。 Legends: FIB=FILL IN THE BLANKS= 填空題 CBSC=CHANGED BUT SAME CONCEPT= 題目有變但概念大致相同 CBSA=CHANGED BUT SAME ANSWER= 題目有變但相同的答案 CH=CHANGED= 題目有變 MDI=MIND THE DISTRUBED ITEMS= 小心干擾的項目 ANS= 正確答案 1
Image of page 1

Subscribe to view the full document.

1. 變題機經 變題機經 by mikeleung110 updated by 27 . Jan .201 8 by MZX Q Details (updated by 02. Jan .201 8 by MZX << 如要參考使用表格內容或作更改的話,請你標註日期的 月份 / 日子排序,因為國內常用 mmddyyyy 跟香港的 ddmmyyyy 不一樣,很混亂,日期的標註真的很 重要 ) 以下是在 63 題出到的內容,後面沒有說明的就表示一樣的內容沒有變,注意答案的選項位置可能有 變化,以下我都盡量精簡說明得非常非常清楚。 ( 讓你們見識一下何謂質素機經,沒有最強的機經, 只有更好更高質素的機經! ( 香港是說質素,反之國內是說素質,真的是給你們玩了 )) 2 3 换了题干,答案一样 CBSA: Replace the equal sign with the IN operator 4 CBSA: into :GROUPS separated by ',' MDI: : into GROUPS separated =',' ( 冒號在 INTO ) 变形 2 :题中给了 c 选项,告诉你用 into :GROUPS separated by ',' ,问 what groups will be stored? ,答 案选 0-29 30-49 50+ 变形 3 Sql 里创建 macro-variable 要求创建 type1, type2, type3, sale1, sale2, sale3 六个宏变量, into : type1 -:type3 , :sale1- :sale3 5 7 9 CH: 改成只有 JONES, 105 ANS: 選沒有 GROUP BY 10 CH: 舊題 9 5 」變 11 5 ANS:2 11 CH: 答案的句子重組了 ( 只是前後調轉了 ); 不重要的小变化 : Work.Errors Work.Missing CBSA: When TEMP is used in another SAS step, data set is created ( 句子重組 ) 12 13 14 有干扰项, describe table 后没有等号! 15 CH: 加了 GROUP BY CODE ANS: JONES 100 SMITH 400 16 变型题,选 intersect corr 。把原题四个选项结果搞清楚就行 17 18 19 只須非常注意 QUOTATION MARK ANS: where upcase(Name)="%upcase(&Value)"; MDI: where upcase(Name)="upcase(&Value)"; 21 22 23 24 和前面有道题很类似,都是考 %eval 25 CH: No 」和 no 」位置互換 ANS:2 27 28 29 2
Image of page 2
30 只須非常注意 QUOTATION MARK 考点不变,单词 / 句子变了: product book merchandise math ANS: %put the value is "&product."; MDI: %put the value is ""&product.""; 31 32 33 CBSC 36 37 CH: EXCEPT ALL 放入 CODE ANS: Lauren Chang Chang 38 CH: 4 」和 10 」位置互換
Image of page 3

Subscribe to view the full document.

Image of page 4
  • Fall '14

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern