Unit - 1 |
|
Section 0-00- Why SAS |
|
00:01:00 |
|
Section 0-01- Course Overview |
|
00:02:00 |
Unit - 2 |
|
Section 2-01- Why is SAS so easy to learn |
|
00:03:00 |
|
Section 2-02- SAS University Edition – download and install |
|
00:10:00 |
|
Section 2-03- Logging-in to SAS after installation |
|
00:01:00 |
|
Section 2-04- SAS Interface and windows |
|
00:06:00 |
Unit - 3 |
|
Section 3-00- Preparing Data – Section Overview |
|
00:01:00 |
|
Section 3-01- SAS Datasets Variables and Obs |
|
00:09:00 |
|
Section 3-02- SAS Libraries |
|
00:05:00 |
|
Section 3-04- Lib Naming Conventions |
|
00:05:00 |
|
Section 3-05- SAS Dataset naming conventions |
|
00:04:00 |
|
Section 3-06- SAS Prog syntax |
|
00:07:00 |
|
Section 3-07- Data and proc step |
|
00:03:00 |
|
Section 3-08- Referencing data in sas |
|
00:05:00 |
|
Section 3-09-01- Bringing data into SAS |
|
00:16:00 |
|
Section 3-09-02- Bringing data into SAS using LIBNAME statement |
|
00:05:00 |
|
Section 3-09-03- Bringing data into SAS using FILENAME |
|
00:05:00 |
|
Section 3-09-04- Bringing data into SAS using DELIMITER option |
|
00:03:00 |
|
Section 3-09-05- Bringing data into SAS using DSD option |
|
00:08:00 |
|
Section 3-09-06- Bringing data into SAS using column input |
|
00:04:00 |
|
Section 3-09-07- Bringing data into SAS using the col pointer |
|
00:02:00 |
|
Section 3-09-08- Bringing data into SAS using the line pointer# |
|
00:07:00 |
|
Section 3-09-09- Bringing data into SAS using the line slash |
|
00:02:00 |
|
Section 3-09-10- Bringing data into SAS using the trailing@ |
|
00:03:00 |
|
Section 3-09-11- Bringing data into SAS using the trailing @@ |
|
00:02:00 |
|
Section 3-09-12- Bringing data into SAS using Proc Import xls |
|
00:07:00 |
|
Section 3-09-13- Bringing data into SAS using Proc Import txt |
|
00:05:00 |
|
Section 3-10- Creating new vars |
|
00:13:00 |
|
Section 3-10-1- Keep, Drop and Rename variables |
|
00:03:00 |
|
Section 3-11-If-else conditional statements |
|
00:16:00 |
|
Section 3-12- Filtering data |
|
00:11:00 |
|
Section 3-13- Sas dates |
|
00:07:00 |
|
Section 3-14-01- SAS functions 1 |
|
00:22:00 |
|
Section 3-14-02- SAS functions 2 |
|
00:17:00 |
|
Section 3-15-01-SAS Formats – Introduction |
|
00:03:00 |
|
Section 3-15-02-SAS Format Statement |
|
00:05:00 |
|
Section 3-15-03-Format Naming Convention |
|
00:09:00 |
|
Section 3-15-03-Format using Put function |
|
00:10:00 |
|
Section 3-16-02-Proc Format |
|
00:17:00 |
|
Section 3-16-SAS Informats |
|
00:14:00 |
|
Section 3-17-01-Program Data Vector- PDV |
|
00:06:00 |
|
Section 3-17-02-PDV Implicit Output |
|
00:15:00 |
|
Section 3-17-03-PDV Explicit Output |
|
00:17:00 |
|
Section 3-18- Do Loops |
|
00:04:00 |
Unit - 4 |
|
Section 4-00- Structuring Data – Section Overview |
|
00:01:00 |
|
Section 4-01-01-Stacking data using a data step |
|
00:06:00 |
|
Section 4-01-02-Stacking data using PROC APPEND |
|
00:15:00 |
|
Section 4-01-03-Interleaving data |
|
00:09:00 |
|
Section 4-02 – Sorting data using PROC SORT |
|
00:15:00 |
|
Section 4-03-01-Removing duplicates-NODUP option |
|
00:11:00 |
|
Section 4-03-02-Removing duplicates-NODUPKEY option |
|
00:11:00 |
|
Section 4-04-01-Simple merging of data |
|
00:09:00 |
|
Section 4-04-02-Merging data using Joins-Introduction |
|
00:08:00 |
|
Section 4-04-03-Merging data using joins-Inner Join |
|
00:16:00 |
|
Section 4-04-04-Merging data using Joins-Full Join |
|
00:07:00 |
|
Section 4-04-05-Merging data using Joins-Left Join |
|
00:06:00 |
|
Section 4-04-06-Merging data using Joins-Right Join |
|
00:04:00 |
|
Section 4-04-07-Merging data using Joins-Far Joins |
|
00:06:00 |
|
Section 4-05-01-Proc SQL – copying data |
|
00:13:00 |
|
Section 4-05-02-Proc SQL – filtering data |
|
00:07:00 |
|
Section 4-05-03-Proc SQL – sorting data |
|
00:08:00 |
|
Section 4-05-04-Proc SQL – removing duplicates |
|
00:05:00 |
|
Section 4-06-01-Transposing data using ID statement |
|
00:13:00 |
|
Section 4-06-02-Transposing data using BY statement |
|
00:14:00 |
|
Section 4-07-01-Retain statement – introduction |
|
00:07:00 |
|
Section 4-07-02-Retain statement – how it is used |
|
00:06:00 |
|
Section 4-07-03-Retain statement – an example |
|
00:08:00 |
Unit - 5 |
|
Section 5-00- Visualizing Data – Section Overview |
|
00:01:00 |
|
Section 5-01-01-Charts – vbar hbar pie |
|
00:11:00 |
|
Section 5-01-02-Vertical Bar Chart – discrete option |
|
00:10:00 |
|
Section 5-01-03-Horizontal Bar Chart – discrete option |
|
00:02:00 |
|
Section 5-01-04-Vertical Bar Chart – groups and subgroups |
|
00:11:00 |
|
Section 5-01-05-Horizontal Bar Chart – groups and subgroups |
|
00:03:00 |
|
Section 5-02- Plots |
|
00:05:00 |
|
Section 5-03-Report Output using PROC PRINT |
|
00:06:00 |
|
Section 5-04-Report Output using PROC REPORT |
|
00:13:00 |
|
Section 5-06-Summary stats – PROC FREQ |
|
00:08:00 |
|
Section 5-06-Summary stats – PROC MEANS |
|
00:03:00 |
|
Section 5-06-Summary stats – PROC UNIVARIATE |
|
00:02:00 |
|
Section 5-07- Output Delivery System (ODS) – Reports |
|
00:02:00 |
|
Section 5-07-01- ODS with PROC FREQ |
|
00:04:00 |
|
Section 5-07-02- ODS with PROC MEANS |
|
00:02:00 |
|
Section 5-07-03- ODS with PROC UNIVARIATE |
|
00:04:00 |
Unit - 6 |
|
Section 6-00- Optimizing Code – Section Overview |
|
00:01:00 |
|
Section 6-01-Macro Variables – introduction |
|
00:14:00 |
|
Section 6-02-Application of macro variables |
|
00:13:00 |
|
Section 6-03-01-Nested macro vars |
|
00:11:00 |
|
Section 6-03-02-More on Ampersand resolutions |
|
00:09:00 |
|
Section 6-04-00-SAS Macros – introduction |
|
00:10:00 |
|
Section 6-04-01-SAS Macros – Examples |
|
00:07:00 |
|
Section 6-05-Macro Functions |
|
00:12:00 |
|
Section 6-06-Bonus lecture |
|
00:02:00 |
Resources |
|
Resources – SAS Programming Basic to Advanced |
|
00:00:00 |
Assignment |
|
Assignment -IT Professional 2.0 Take Your Career To The Next Level |
|
05:00:00 |