Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
Learn how to make a genuine difference in your life by taking our popular [course_title]. Our commitment to online learning and our technical experience has been put to excellent use within the contents of these educational modules. By enrolling today, you can take your knowledge of Programming  to a whole new level and quickly reap the rewards of your study in the field you have chosen.
We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.
Please Note that [course_title] provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practices. Always check details with the appropriate authorities or management.
By completing the training in [course_title], you will be able to significantly demonstrate your acquired abilities and knowledge of Programming . This can give you an advantage in career progression, job applications, and personal mastery in this area.
This course is designed to provide an introduction to Programming Using MacrosSQLÂ and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported and it can take just 20 to 30 hours to gain accreditation, with study periods being entirely customisable to your needs.
Once you have completed all the modules in the [course_title] course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.Â
The learners have to successfully complete the assessment of this [course_title] course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
Unit - 1 | |||
Section 0-00- Why SAS | 00:01:00 | ||
Unit - 2 | |||
Section 2-02- SAS Studio through SAS OnDemand- Registration | 00:04: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- Section Overview – Macros | 00:01:00 | ||
Section 3-01-Macro Variables – introduction | 00:14:00 | ||
Section 3-02-Application of macro variables | 00:13:00 | ||
Section 3-03-01-Nested macro vars | 00:11:00 | ||
Section 3-03-02-More on Ampersand resolutions using a cool example | 00:09:00 | ||
Section 3-04-00-SAS Macros – introduction | 00:10:00 | ||
Section 3-04-01-SAS Macros – Examples | 00:07:00 | ||
Section 3-04-02-Keyword positional and mixed params | 00:06:00 | ||
Section 3-04-03-Conditional Logic in Macros | 00:11:00 | ||
Section 3-05-Macro Functions | 00:12:00 | ||
Section 3-05-Options Statement- mprint-mlogic-symbolgen | 00:13:00 | ||
Section 3-07-Connecting the two worlds – Call Symput – Symget | 00:14:00 | ||
Section 3-09-01-02- Bringing data into SAS using Import Wizard | 00:04: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 | ||
Unit - 4 | |||
Section 4-00- Section Overview – Proc SQL | 00:01:00 | ||
Section 4-01-01-Proc SQL – copying data | 00:13:00 | ||
Section 4-01-02-Proc SQL – filtering data | 00:07:00 | ||
Section 4-01-03-Proc SQL – sorting data | 00:08:00 | ||
Section 4-01-04-Proc SQL – removing duplicates | 00:05:00 | ||
Section 4-02-01-Proc SQL – Union | 00:09:00 | ||
Section 4-02-02-Proc SQL – Except | 00:04:00 | ||
Section 4-02-03-Proc SQL – Intersect | 00:02:00 | ||
Section 4-03-00-Merging data using Joins-Introduction | 00:08:00 | ||
Section 4-03-01-Proc SQL – inner join | 00:14:00 | ||
Section 4-03-02-Proc SQL – full join | 00:08:00 | ||
Section 4-03-03-Proc SQL – left and right joins | 00:07:00 | ||
Section 4-04-01-Proc SQL – creating macro vars | 00:07:00 | ||
Unit - 5 | |||
Section 5-00- Bonus lecture | 00:02:00 | ||
Resources | |||
Resources – Advanced SAS Programming Using MacrosSQL | 00:00:00 |
3674
4.3
£25
1961
4.6
£25