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 |
No reviews found for this course.
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.