SAS认证考试.doc

《SAS认证考试.doc》由会员分享，可在线阅读，更多相关《SAS认证考试.doc（22页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、【精品文档】如有侵权，请联系网站删除，仅供学习与交流SAS认证考试.精品文档.SAS Global Certification program一、SAS Certified Base Programmer for SAS 9 Credential1, OverviewThe SAS Certified Base Programmer for SAS 9 credential is the ideal certification for those relatively new to SAS programming or new to SAS certification. It is also

2、the principle certification for other advanced certifications available from SAS. Candidates should be familiar with the enhancements and new functionality that are available in SAS 9.2. Successful candidates should have experience in programming and data management using SAS 9 and should be able to

3、: import and export raw data files manipulate and transform data combine SAS data sets create basic detail and summary reports using SAS procedures identify and correct data, syntax and programming logic errors. To earn this credential you must pass the SAS Base Programming for SAS 9 Exam2, Exam con

4、tentRequired ExamCandidates who earn this credential will have earned a passing score on the SAS Base Programming for SAS 9 Exam. This exam is administered by SAS and Prometric. 70 multiple-choice questions (must achieve score of 65% correct to pass) 2 hours to complete exam Use exam ID A00-211; req

5、uired when registering with Prometric. Exam topics include:Accessing Data Use FORMATTED and LIST input to read raw data files. Use INFILE statement options to control processing when reading raw data files. Use various components of an INPUT statement to process raw data files including column and l

6、ine pointer controls, and trailing controls. Combine SAS data sets. Access an Excel workbook. Creating Data Structures Create temporary and permanent SAS data sets. Create and manipulate SAS date values. Export data to create standard and comma-delimited raw data files. Managing Data Investigate SAS

7、 data libraries using base SAS utility procedures. Sort observations in a SAS data set. Use assignment statements in the DATA step. Modify variable attributes using options and statements in the DATA step. Accumulate sub-totals and totals using DATA step statements. Use SAS functions to manipulate c

8、haracter data, numeric data, and SAS date values. Use SAS functions to convert character data to numeric and vice versa. Process data using DO LOOPS. Process data using SAS arrays. Validate and clean data. Generating Reports Generate list reports using the PRINT procedure. Generate summary reports a

9、nd frequency tables using base SAS procedures. Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting. Generate HTML reports using ODS statements. Handling Errors Identify and resolve programming logic errors. Recognize and correct syntax errors. Examine

10、and resolve data errors. 3, Exam PreparationExperience is a critical component to becoming a SAS Certified Professional. The below diagram illustrates training options available to help you prepare for this credentials required examination. Be sure to check your local countrys preparation bundles wh

11、ich often include an exam voucher. View the sample questions for this exam.For certification candidates in the U.S. and Canada: Best Value deals! Save up to 50%All you need to prepare in one package - at one low price! Packages designed to suit every learning style: classroom, e-Learning, or book 4,

12、 Exam RegistrationRegistration Options OnlineVisit Follow these easy steps once on the site: 1. Select the first box Schedule a Test 2. Select Schedule an Appointment 3. Choose your country and state/province if applicable 4. Insure that SAS Institute is selected as your client and program 5. Select

13、 your desired SAS certification exam 6. Review available testing sites and select Schedule Appointment First-time registration with Prometric requires a 24-hour waiting period before the candidate can schedule an exam online. Candidates who are registering for an exam for the first time will receive

14、 an email confirmation from Prometric within 24 hours to begin the online scheduling process. Candidates who have previously tested with Prometric and have their Prometric ID or have previously registered online can schedule their exam online immediately. TelephoneBy phone in the U.S. and Canada: 88

15、8-895-5819 between 7:00 a.m. and 7:00 p.m. CST By phone outside the U.S. and Canada, visit for a list of exam registration phone numbers. Testing LocationsTo find your nearest testing center, visit Information required upon registrationPlease be prepared to provide the following information to Prome

16、tric when registering: 1. First and last name - Please provide your name as you would like it to appear on your certificate. 2. Prometric assigns a unique identification number to each candidate. Please use this ID number each time you schedule an exam with Prometric or SAS. 3. Mailing address - Ple

17、ase list the address to which all correspondence should be mailed. 4. Company name - If you have listed your business address, please include your company name to ensure appropriate routing. 5. E-mail address - For the latest program updates, email is the most efficient and effective means of contac

18、ting you. 6. Contact phone numbers 7. Exam number and title 8. Testing center preference - To find your nearest testing center, visit 9. Method of payment (credit card (American Express, Mastercard, and Visa), vouchers) Payment options may vary by country. If your address has changed since you last

19、registered for an exam, please contact Prometric to update your demographic information. Exam PricingWithin North America and India, the cost associated with an exam offered through Prometric is US $180. The same in China.Certification exam prices are subject to change. In some countries, different

20、pricing and additional taxes may apply. Please visit for exam pricing in your country. Faculty, staff, and full-time students of degree-granting institutions are eligible for a discount on SAS Certification exams. Candidates in the United States and Canada receive a 50% discount. International candi

21、dates should contact your local office for discount information. Cancellation PolicyCandidates may cancel or reschedule exams at no charge if they contact the Prometric Regional Service Center by 6:00 p.m. ET at least one business day prior to the scheduled exam date. Candidates who do not appear fo

22、r the test or cancel less than one business day before the exam will not receive a refund. Retake PolicyCandidates may attempt each SAS Certified Professional exam up to three times in a twelve-month period, waiting a minimum of 30 calendar days between attempts. Exams that do not comply with the re

23、take examination policy will be considered invalid. Exam retakes require payment of the full exam fee and are not discounted. Candidate AgreementCandidates are encouraged to review the SAS Institute Inc. Certification Program Agreement prior to their exam day.5, Exam DayWhat to bring: Certification

24、candidates are required to provide two forms of identification at the testing center, including one photo identification such as a drivers license or a valid passport. Both forms must display the candidates signature. Arriving at the test center: Candidates should plan to arrive 15 minutes before th

25、eir scheduled exam time. Candidates arriving more than 15 minutes late are not guaranteed exam availability or a refund. Reference materials: To maintain the security of the test environment, candidates are not permitted to bring reference materials of any kind into the testing center. Personal item

26、s: The only items allowed in the testing area are your identification. Please leave any backpacks, laptops, briefcases and other personal items at home. If you have personal items that cannot be left behind (such as purses), the testing center may have lockers available for use. No cameras, cell pho

27、nes, audio players, or other electronic devices are allowed during exam sessions. Please refer to Prometric Testing Center Regulations for more information. All notes will be collected at the end of testing and no material may be removed from the testing event.6, After the ExamScore ReportYou will r

28、eceive an immediate pass/fail score upon completion of your exam attempt at your testing facility. The score report will display the percentage of items in each section that you answered correctly for the your exam. Please note: These section scores are calculated on a per section basis and cannot b

29、e used in determining your total score. They are provided to you for descriptive purposes only. Welcome E-mail and CertificateIf you have passed your exam and met all requirements for this credential, you will receive two e-mails. One e-mail will contain your logo access and welcome information. The

30、 second e-mail will include a pdf copy of your certificate which you can print at any time. These e-mails will be sent to the e-mail address you provided to Prometric at exam registration. Please allow at least two weeks from your exam date to receive your e-mails. Directory ListingUpon receipt of y

31、our credentials from SAS, your name will be added to the SAS Certified Professional Directory Listing. This process can take up to one week after your certificate is awarded. If you do not wish for your name to appear in the SAS Certified Professional Directory listing, you may chose to be excluded

32、at the time of exam registration. 二、SAS Certified Advanced Programmer for SAS 9 Credential1, over viewThe SAS Certified Advanced Programmer for SAS 9 credential represents the upper echelon of SAS programmers. Those who earn the advanced programming credential have demonstrated a high level of profi

33、ciency in SAS programming expertise and are a much sought after commodity in the global job market. A SAS advanced programmer should have current SAS programming and data management experience. Successful candidates should be skilled in tasks such as using advanced DATA step programming statements a

34、nd efficiency techniques to solve complex problems writing and interpreting SAS SQL code creating and using the SAS MACRO facility. Candidates for the SAS Advanced Programmer for SAS 9 exam should be familiar with enhancements and new functionality that are available in SAS 9.2. The candidate must c

35、urrently hold a SAS Certified Base Programmer for SAS 9 credential.2, exam contentRequired ExamCandidates who earn this credential will have taken and earned passing scores of the following two exams: 1) SAS Base Programming Exam for SAS 9, and 2) SAS Advanced Programming Exam for SAS 9. This exam i

36、s administered by SAS and Prometric. 63 multiple-choice questions (must achieve score of 65% correct to pass) 2 hours to complete exam Use exam ID A00-212; required when registering with Prometric. Exam topics include:Accessing Data Using SQL Generate detail reports by working with a single table, j

37、oining tables, or using set operators in the SQL procedure. Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure. Construct sub-queries and in-line views within an SQL procedure step. Compare solving a problem using the SQL procedure ve

38、rsus using traditional SAS programming techniques. Access Dictionary Tables using the SQL procedure. Macro Processing Create and use user-defined and automatic macro variables within the SAS Macro Language. Automate programs by defining and calling macros using the SAS Macro Language. Understand the

39、 use of macro functions. Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log. Create data-driven programs using SAS Macro Language. Advanced Programming Techniques Demonstrate the use of advanced data lo

40、ok-up techniques such as array processing, hash objects, formats, and combining/merging data. Reduce I/O by controlling the space required to store SAS data sets using compression techniques, length statements, or eliminating variables and observations. Reduce programming time by developing reusable

41、 SAS programs which incorporate data step views, DATA steps that write SAS programs, and the FCMP procedure. Perform effective benchmarking by using the appropriate SAS System options and interpreting the resulting resource utilization statistics. Determine the resources used by the SORT procedure a

42、nd avoid unnecessary sorts by using appropriate indexes, data set options, BY statement options, and the CLASS statement. Identify appropriate applications for using indexes and create them using the DATA step, the DATASETS procedure, or the SQL procedure. Compare techniques to eliminate duplicate d

43、ata using the DATA step, the SORT procedure, and the SQL procedure.2, exam preparation.Experience is a critical component to becoming a SAS Certified Professional. The below diagram illustrates training options available to help you prepare for this credentials required examination. Be sure to check

44、 your local countrys preparation bundles which often include an exam voucher. For more informationContact the SAS Global Certification Program at certification or 800-333-7660.三、SAS Certified Platform Administrator 9 CredentialThis credential is designed for those IT administrators responsible for i

45、nstalling, configuring, administering and maintaining the platform for SAS Business Analytics1， OverviewThe SAS Certified Platform Administrator for SAS 9 credential is the ideal certification for those who have the skills and knowledge necessary for the administration of the platform for SAS Busine

46、ss Analytics. Successful candidates should be able to: Secure the SAS configuration on each server machine Check status and operate servers Monitor server activity and administer logging Establish formal, regularly scheduled backup processes Add users and manage their access Establish connectivity t

47、o data sources Set up and secure metadata folder structures Administer repositories and move metadata To earn this credential, you must pass the SAS Certified Platform Administration for SAS 9 exam. 2， Exam ContentRequired ExamCandidates who earn this credential will have earned a passing score on the SAS Platform Administration for SAS 9 exam. This exam is administered by SAS and Prometric. 65 multiple-choice questions (must achieve score of 69% correct to pass) 2 hours to complete exam Use exam ID A00-250; required when registering with Pr