SAS Global Certification FOUNDATION

SAS Global Certification FOUNDATIONSAS Certified Base Programmer for SAS 9 SAS Certified Advanced Programmer for SAS 9 SAS Clinical Trials Programmer Using SAS 9 Grow with ussas.com/certify70 28 29 73saskurser@sas.com

SAS Certified BaseProgrammer for SAS 9Credential Use SAS functions to manipulate characterdata, numeric data and SAS date values. Use SAS functions to convert character datato numeric and vice versa. Process data using DO loops and SAS arrays. Validate and clean data.EXAM TO COMPLETESAS Base Programming for SAS 9 AUDIENCESuccessful candidates for this exam should havethe following programming and data managementexperience: Import and export raw data files. Manipulate and transform data.Generating Reports Generate list reports using the PRINT procedure. Generate summary reports and frequency tablesusing Base SAS procedures. Enhance reports through the use of user-definedformats, titles, footnotes and SAS systemreporting options. Generate HTML reports using ODS statements. Combine SAS data sets.Handling Errors C reate basic detail and summary reportsusing SAS procedures. Identify and resolve programming logic errors. I dentify and correct data syntax andprogramming logic errors. Examine and resolve data errors.EXAM CONTENT Recognize and correct syntax errors.EXAM PREPARATION OPTIONSAccessing DataExperience is a critical component to becominga SAS Certified Professional. Use FORMATTED and LIST input to readraw data files.SAS Education provides the following trainingcourses to help you prepare. Use INFILE statement options to controlprocessing when reading raw data files. Use various components of an INPUT statementto process raw data files, including column andline pointer controls, and trailing @ controls. Combine SAS data sets using the DATA step. Access and Excel workbook.Creating Data Structures Create temporary and permanent SAS data sets. Create and manipulate SAS date values. Export data to standard and comma-delimitedraw data files.Managing Data Investigate SAS data libraries using Base SASutility procedures. Sort observations in a SAS data set. Conditionally execute SAS statements. Usingthe DATA step to modify variable attributes usingoptions and statements, accumulate subtotalsand totals, and use assignment statements. Startkursus: Databehandling ograpportering med SAS-kode SAS Programming 2:Data Manipulation Techniques SAS Base Programmingfor SAS 9 exam

SAS Certified AdvancedProgrammer for SAS 9Credential Use various system options that are availablefor macro debugging and displaying valuesof user-defined and automatic macro variablesin the SAS log.CREDENTIAL HELDAdvanced Programming Techniques SAS Base Programming for SAS 9 EXAM TO COMPLETE SASAdvanced Programmingfor SAS 9 AUDIENCESuccessful candidates for this exam should holda SAS Certified Base Programmer for SAS 9credential and have current programming anddata management experience using SAS 9 to: Create data-driven programs using theSAS Macro Language. Demonstrate the use of advanced data look-uptechniques such as array processing, hash objects,formats, and combining/merging data. Reduce I/O by controlling the space requiredto store SAS data sets using compressiontechniques, length statements, or eliminatingvariables and observations. Reduce programming time by developing reusableSAS programs that incorporate DATA step views,DATA steps that write SAS programs, and theFCMP procedure. Write efficient SAS code to solve complexproblems in accordance with system specifications,while minimizing use of computing resources. Use advanced DATA step programmingstatements and efficiency techniques. Write and interpret SAS SQL code. Use the SAS MACRO facility.EXAM CONTENTAccessing Data Generate detail reports by working witha single table, joining tables, or using setoperators in the SQL procedure. Generate summary reports by working witha single table, joining tables, or using setoperators in the SQL procedure. Construct subqueries and in-line viewswithin an SQL procedure step. Compare solving a problem using theSQL procedure versus using traditionalSAS programming techniques. Access Dictionary Tables using theSQL procedure. Perform effective benchmarking by using theappropriate SAS system options and interpretingthe resulting resource utilization statistics. Determine the resources used by the SORTprocedure and avoid unnecessary sorts byusing appropriate indexes, data set options, BYstatement options, and the CLASS statement. Identify appropriate applications for usingindexes and create them using the DATA step,the DATASETS procedure, or the SQL procedure. Compare techniques to eliminate duplicate datausing the DATA step, the SORT procedure, andthe SQL procedure.EXAM PREPARATION OPTIONSExperience is a critical component to becominga SAS Certified Professional. SAS Education provides the following trainingoptions to help you prepare. Remember, you musthold the Base programmer credential before sittingfor the Advanced programmer exam.SAS Certified Base Programmer for SAS 9 ANDSAS Macro Language 1:Essentials Macro Processing Create and use user-defined and automaticmacro variables within the SAS Macro Language. Automate programs by defining and callingmacros using the SAS Macro Language. Understand the use of macro functions. SAS SQL 1: Essentials SAS Programming 3:Advanced Techniques andEfficiencies SAS Advanced Programmingfor SAS 9 exam

SAS Clinical TrialsProgrammer Using SAS 9Credential Apply observation carry forward techniques toclinical trials data. Obtain counts of events and calculate changefrom baseline results.Statistics and MacrosEXAM TO COMPLETE SASClinical Trials ProgrammingUsing SAS 9 OR Obtain descriptive statistics for clinical trials data. Use PROC FREQ and TTEST to obtain p-values. Create output data sets from SAS statisticalprocedures. Create and use macro variables. SASCertified Base Programmingfor SAS 9 Define and call macros. Debug macros with system options.Report Clinical Trials Results SASClinical Trials ProgrammingUsing SAS 9 – Accelerated Version Use PROC REPORT to produce tables and listings. Use ODS and global statements to produce andaugment reports.AUDIENCESuccessful candidates for this exam should haveexperience in:Validate Clinical Trial Data Reporting Clinical trials process. Explain the principles of programming validationin the clinical trials industry. Accessing, managing and transforming clinicaltrials data. Utilize the log file to validate clinical trialdata reporting. Statistical procedures and macro programming. Reporting clinical trials results. Use programming techniques to validateclinical trial data reporting. Validating clinical trial data reporting. Identify and resolve data, syntax and logic errors.EXAM CONTENTEXAM PREPARATION OPTIONSClinical Trials ProcessExperience is a critical component to becominga SAS Certified Professional. Describe the clinical research process. Work with Statistical Analysis Plans and annotatedCase Report Forms. Describe regulatory requirements. SAS Education provides several training optionsto help you prepare for this exam. Please visitour website for details on how to prepare.sas.com/certify Work with clinical trials data structures, includingCDISC SDTM and ADaM data models.Clinical Trials Data Combine SAS data sets and access Excel workbooks. Efficiently import, subset, transpose and sortdata sets. Apply regulatory requirements to exportedSAS data sets. Investigate SAS data libraries using SAS utilityprocedures and DICTIONARY Tables. Create and modify variable attributes. Process data with DO LOOPS, arrays andRETAIN statements. Apply categorization techniques to clinical trials data.REGISTRATIONThese exams are administered by Pearson VUE.Get registration details on our website.sas.com/certifyFOR MORE INFORMATION Web: sas.com/certify Email: saskurser@sas.com Call: 70 28 29 73

SAS Institute Inc.To contact your local SAS office, please visit:70 28 29 73sas.com/officesSAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USAand other countries. indicates USA registration. Other brand and product names are trademarks of their respective companies.Copyright 2013, SAS Institute Inc. All rights reserved. S104654-found.0213

a SAS Certified Professional. SAS Education provides the following training options to help you prepare. Remember, you must hold the Base programmer credential before sitting for the Advanced programmer exam. AND SAS Certified Base Programmer for SAS 9 SAS Macro Language 1: Essentials SAS