This course will focus on the aspects of working with data structures and algorithms using Javascript - FCS

SAS Programming BASE certification course for SAS Beginners Course Site

suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4

What you’ll learn

SAS Programming BASE certification course for SAS Beginners Course Site

This course is suitable for the new practical BASE programming credential: SAS Certified Specialist: Base Programming Using SAS 9.4
Software installation (SAS University Edition /SAS studio): the complete & step-by-step guide; detailed explanation on File path/directory in SAS studio
Get Data in various format into SAS: (read .txt file, .csv file, Excel file, format input (using SAS information to read dates; use SAS format to display SAS date values). Proc Import, Proc Export, Proc Content)
Create temporary and permanent SAS data sets (SET statement, LIBNAME statement, SAS libraries )
Combine data sets (Concatenate, Append, interleave, Match Merge (one-to-one merge, one-to-many merge))
Use SAS functions to manipulate SAS date values (Explanation on how SAS stores date and time values, SAS functions include MDY, YEAR, QTR, MONTH, DAY, WEEKDAY, TODAY, DATE, INTCK, DATDIF, YRDIF)
Use SAS functions to manipulate character and numeric data values (use SAS functions to Convert Character & Numeric Value (auto-convert; PUT & INPUT functions), Other SAS functions include: SCAN, SUBSTR, TRIM, UPCASE, LOWERCASE, PROPCASE, CATX, INDEX, TRANWRD, INT, ROUND)
Simplify your data with Array (One-dimensional array; two-dimensional array; Creating Variables in an ARRAY Statement; Assigning Initial Values to Arrays & Creating Temporary Array Elements)
Process data with DO LOOPS (the basic of DO LOOPS; constructing DO LOOPS;
Work with data & Creating labels and formats (Use assignment statements in the DATA step; Use LABEL and FORMAT statements to modify attributes in a DATA step; Define the length of a variable using the LENGTH statement; Control which observations and variables using DROP, KEEP statements and DROP=, KEEP= options, and IF statement)
Generate list reports using the PRINT procedure (using VAR, SUM, WHERE, ID and BY statements)
Generate reports using ODS statements (Identify ODS destinations, create HTML, PDF, RTF, and Excel files with ODS statements)
Reconstruct/Reshape SAS Data sets in the DATA step and using Proc TRANSPOSE
SAS advanced topic: Proc SQL Essentials
SAS advanced topic: SAS Macros Essentials

Requirements

Basic computer skills

Description

Do you want to start learning SAS programming easily and quickly? This course is the most complete SAS BASE certification programming course for

absolute SAS beginners
anyone interested in passing the SAS BASE certification exam
suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4
Coding exercises and projects are perfect for the practical coding questions for the new SAS BASE certificate exam

Course Highlights:

step by step/ code by code explanations for easy and efficient learning experiences
most complete SAS BASE course for beginners and the SAS BASE certification exam(suitable for the new practical SAS programming certificate: SAS Certified Specialist: Base Programming Using SAS 9.4)1. SAS programming for beginners2. SAS programming on data manipulation and preparation part 1: modify variables3. SAS programming on data manipulation and preparation part 2: combine/merge data sets4. Overview / Essentials for SAS advanced topics: SAS SQL (Proc SQL) and SAS Macro Language5. Additional topics: Error handling, Generate reports using ODS statements
downloadable data and SAS programs used in the course (the course materials are ONLY for practice, they are protected by copyright)
Quizzes, coding exercises and projects for practice.Coding exercises and projects are perfect for the practical coding questions for the new certificate exam on SAS Certified Specialist: Base Programming Using SAS 9.4

Current course contents: (Please see course curriculum for more detailed information on sections and lectures included in this course)

Software installation (SAS University Edition /SAS studio): the complete & step-by-step guide; detailed explanation on File path/directory in SAS studio
Navigate/work in the SAS environment
Get Data in various format into SAS: (read .txt file, .csv file, Excel file, format input (using SAS information to read dates; use SAS format to display SAS date values). Proc Import)
Create temporary and permanent SAS data sets (SET statement, LIBNAME statement, SAS libraries )
Combine data sets (Concatenate, Append, interleave, Match Merge (one-to-one merge, one-to-many merge))
Use SAS functions to manipulate SAS date values (Explanation on how SAS stores date and time values, SAS functions include MDY, YEAR, QTR, MONTH, DAY, WEEKDAY, TODAY, DATE, INTCK, DATDIF, YRDIF)
Use SAS functions to manipulate character and numeric data values (use SAS functions to Convert Character & Numeric Value (auto-convert; PUT & INPUT functions), Other SAS functions include: SCAN, SUBSTR, TRIM, UPCASE, LOWERCASE, PROPCASE, CATX, INDEX, TRANWRD, INT, ROUND)
Simplify your data with Array (One-dimensional array; two-dimensional array; Creating Variables in an ARRAY Statement; Assigning Initial Values to Arrays & Creating Temporary Array Elements)
Process data with DO LOOPS (the basic of DO LOOPS; constructing DO LOOPS;
Work with data & Creating labels and formats (Use assignment statements in the DATA step; Use LABEL and FORMAT statements to modify attributes in a DATA step; Define the length of a variable using the LENGTH statement; Control which observations and variables using DROP, KEEP statements and DROP=, KEEP= options, and IF statement)
Generate list reports using the PRINT procedure (using VAR, SUM, WHERE, ID and BY statements)
Generate reports using ODS statements (Identify ODS destinations, create HTML, PDF, RTF, and Excel files with ODS statements)
Reconstruct/Reshape SAS Data sets in the DATA step and using Proc TRANSPOSE
SAS advanced topic: Proc SQL Essentials
SAS advanced topic: SAS Macros Essentials