What you'll learn;
1.All critical and essential SAS BASE Data manipulation and data preparation skills
2.Handle Error by identify and solve SAS errors
3.Combine, merge and restructure data sets
4.SAS Statistical Procedures
6.SAS advanced topic: Proc SQL Essentials
7.SAS advanced topic: SAS Macros Essentials
-Navigate/work in SAS environment.
-Get Data in various format into SAS: (read .txt file, .csv file, Excel file, format input (using SAS informat 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, LOWCASE, PROPCASE, CATX, INDEX, TRANWRD, INT, ROUND).
-Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements.
-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; Conditionally Executing DO Loops using DO UNTIL and DO WHILE; Using Conditional Clauses with the Iterative DO Statement).
-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).
-SAS Statistical Procedures: Proc SORT; Proc PRINT; Proc MEANS; Proc FREQ; Proc UNIVARIATE, Proc Export, Proc Content.
-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 DATA step and using Proc TRANSPOSE.
-SAS advanced topic: Proc SQL Essentials.