There is now a new Training Course list for 2017

There is now a new Training Course list for 2017, which can be downloaded from here. The courses available in 2016 are still there, but I’m developing some new SAS-related courses, based on the SAS course, which you can accelerate to production status by requesting them:

  • ½ day SAS Data Step training
  • ½ day SAS PROC SQL training
  • ½ day SAS macros training
  • ½ day Defensive SAS Programming training

Your interest in any of these courses will result in them being developed as priority tasks!

What is the SAS Programming Forum and why does it cost to access?

It is rather sad that everyone knows the price of everything and the value of nothing! I have paraphrased this statement somewhat from the original written by Oscar Wilde for Lord Darlington in “Lady Windemere’s Fan”, but the reality is very much in evidence everywhere today. But how is that relevant to the SAS Programming Forum?

I wanted to create a place where students of SAS programming (which includes myself, as I try to learn something new about SAS every day) could ask SAS-related questions, even if they were from interviews or homework, without being criticised. However, I wanted to exclude those asking questions because they were too lazy to research the answers themselves (#LAZYWEB), so I hoped that charging a small amount to access the forum would filter out those trying to get free information with no effort, but encourage those enthusiastic enough to pay to learn about SAS an opportunity to do so. The SAS Programming Forum subscription is only GBP 5.00 per month for up to 3 months via PayPal, so it can be stopped at any time, but also renewed easily, and includes access to my SAS course about SAS programming topics, which I’m progressively building, and currently includes 4 sections on SAS components, Data Steps, PROC SQL and SAS macros, and now totals 25 topics in all. The sections are intended to be read sequentially, but are, for the most part, independent of each other. The key feature of the SAS Programming Forum and the SAS course is that questions can be asked at any time and they will be answered, provided sufficient information is given in the question. This is not a “get out” clause, but a learning point for all prospective SAS programmers that without sufficient information you cannot write a SAS program that meets the customer’s needs, so you have to be able to ask question yourself!

The SAS macros section has been added to the SAS course

The SAS course and the SAS Programming Forum continue to grow, I have just added a new course section about SAS macros, and there are now 23 topics in 4 different sections:

  • [A] SAS components – 2 topics
  • [B] Data Steps – 13 topics
  • [F] PROC SQL – 6 topics
  • [G] Macros – 2 topics (2 new topics!)

The SAS course topics themselves are in the SAS Programming Forum, which can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

The SAS Programming Forum is growing: a new SAS course topic posted and another SAS question answered

The SAS course and the SAS Programming Forum continue to grow, I have just added a new course topic about the PROC SQL data set combining, and there are now 21 topics in 3 different sections:

  • [A] SAS components – 2 topics
  • [B] Data Steps – 13 topics
  • [F] PROC SQL – 6 topics (1 new topic!)

The SAS course topics themselves are in the SAS Programming Forum, which can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

I’ve also added an answer to a new SAS-related question in the SAS Programming Forum about re-ordering data sets without using PROC SORT. Again this topic can only be accessed by Programmer level members.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

Another new post in the SAS course making a total of 20 topics in 3 sections

The SAS course continues to grow, I have just added a new topic about the PUT statement, and there are now 20 topics in 3 different sections:

  • [A] SAS components – 2 topics
  • [B] Data Steps – 13 topics (1 new topic!)
  • [F] PROC SQL – 5 topics

The SAS course topics themselves can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

Are you learning about SAS?

Anyone learning about SAS can take advantage of the SAS University Edition. This can be downloaded to your Windows or Linux platform as a free virtual machine compatible with VirtualBox or VMware Player (both free too!), or accessed online through an Amazon AWS environment (also free!). Full details about what you need to do can be found at http://www.sas.com/en_us/software/university-edition.html. Just follow the Get free software link on this web page.

Note that this version of SAS must only be used for learning about SAS, and is not intended for commercial use. The full list of permitted uses for the SAS University Edition can be found here.

The SAS course now has 16 topics in 3 sections

The SAS course continues to grow, and now has 16 topics in 3 different sections:

  • [A] SAS components – 2 topics
  • [B] Data Steps – 11 topics
  • [F] PROC SQL – 3 topics

The SAS course topics themselves can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

A new SAS course section about PROC SQL has been started

While I have been working on the final topic(s) for the Data Steps section of the SAS course on the FILE & PUT statements, I have read a number of questions on the web about PROC SQL syntax. I was not going to start this section until somewhat later, but I have decided to publish the first few topics to explain some of the most useful PROC SQL syntax, so look out for the following topics in the next few weeks:

  • SELECT & FROM
  • ORDER BY
  • GROUP BY & HAVING
  • Joins, WHERE & ON
  • INTO
  • DISTINCT
  • Summary functions

The SAS course topics can only be accessed by Programmer level members, but Free members can read the SAS course – Home page.

Data Steps section of my SAS course is nearing completion

I’m currently working on the final topic(s) for the Data Steps section of the SAS course on the FILE & PUT statements, which also includes information about FILENAME and ABORT statements too. Currently I’m splitting this topic into 4 sub-topics, to make it more manageable, which will be published before the end of the month.

The next section will focus on SAS procedures, and then I’ll be working on a section about reading external files.

The SAS course topics can only be accessed by Programmer level members, but Free members can read the SAS course – Home page.

2 new topics now in the SAS course, and an extension to an existing topic

You will need to have, at least, Free membership of my SAS blog to access the SAS course home page, which is made up of sections containing SAS-related topics, with new topics and sections posted over time.

The SAS course now has 2 sections, updated with 2 new topics (about formats and informats) and another extended topic (about DO loops, including information about arrays) available, making a total of 10 topics in the SAS Programming Forum. Note that the course topics themselves are not available to registered members with Free membership, so to upgrade your membership please click here.

More topics and sections are being developed, so register now for free to be kept informed about all of the news…