I’m presenting “Using SAS Studio Tasks to Plot with ODS Graphics” at the SAS Forum UK in Birmingham on 27Sep2016

Loading

I’m presenting “Using SAS Studio Tasks to Plot with ODS Graphics” at the SAS Forum UK in Birmingham on 27Sep2016. You can download my paper and presentation from here.

Hope to see you in Birmingham.

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

Loading

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
  • 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

Loading

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
  • 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!

The SAS course now has 19 topics in 3 sections

Loading

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

  • [A] SAS components – 2 topics
  • Data Steps – 12 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!

I’ve added an explanation of what each membership level can do

Loading

The most up-to-date version of the following table can be found here, but with extra links there to help you register for the correct membership level on this site. Each membership level builds on the previous level, so for each successive level the blue boxes highlight the new areas and access added:

Membership level Blog & Forums Access
Not logged in Blog posts Read
SAS Skills Discussion Forum Read linked topics only
SAS Job Listings Read
Free membership Blog posts Read & Comment
SAS Skills Discussion Forum Read and Write Topics & Reply
SAS Job Listings Read
Programmer membership (includes Free membership) Blog posts Read & Comment
SAS Skills Discussion Forum Read and Write Topics & Reply
SAS Programming Forum Read and Write Topics & Reply
SAS course Read Topics & Reply
SAS Job Listings Read
Recruiter membership (includes Programmer membership) Blog posts Read & Comment
SAS Skills Discussion Forum Read and Write Topics & Reply
SAS Programming Forum Read and Write Topics & Reply
SAS course Read Topics & Reply
SAS Job Listings Read & Post New Jobs

The SAS course now has 18 topics in 3 sections

Loading

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

  • [A] SAS components – 2 topics
  • Data Steps – 11 topics
  • [F] PROC SQL – 5 topics (2 new 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!

You may not be able to access my blog!

Loading

Hi everyone,

I’ve updated my blog site to fix a bug in the forum software, and you may not now be able to access the site in the way you’ve done so in the past. Using http://blog.hollandnumerics.org.uk will still work, but any web addresses including “:8000” will now fail.

You have 2 choices:

Why has the change been made?

When the site was accessed using port 8000, the forum software bbPress would not accept replies to forum topics. It should have done so, but it just didn’t work. Using port 80 (the default for web sites) bbPress will now successfully accept replies to forum topics, so please feel free to ask questions, and offer suggestions in forum replies.

I’m now looking forward to your topic replies.

…………Phil

Are you learning about SAS?

Loading

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.

You can use SAS University Edition with all of the topics in the SAS course on this site, except SAS Enterprise Guide.

The SAS course now has 16 topics in 3 sections

Loading

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

  • [A] SAS components – 2 topics
  • 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

Loading

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.

Reminder that I still have the SAS-related apps available in Google Play, Amazon Appstore and Chrome Web Store

Loading

This is quick reminder that I still have the following apps available in Google Play:

  • Data Steps: Do This in SAS?
  • SQL: Do This in SAS?
  • Graphs: Do This in SAS?
  • Platforms: Do This in SAS?
  • EG: Do This in SAS?
  • Macros: Do This in SAS?
  • Efficiency: Do This in SAS?
  • Studio: Do This in SAS?

These apps are also available for Android users in the Amazon Appstore, or for Chrome and Chromium desktop browser users in the Chrome Web Store:

  • Data Steps: How Do You Do This in SAS?
  • SQL: How Do You Do This in SAS?
  • Graphs: How Do You Do This in SAS?
  • Platforms: How Do You Do This in SAS?
  • EG: How Do You Do This in SAS?
  • Macros: How Do You Do This in SAS?
  • Efficiency: How Do You Do This in SAS?
  • Studio: How Do You Do This in SAS?

There are also free apps, which you can find by searching in each app store:

  • How Do You Do This in SAS? (Google Play, Amazon Appstore and Chrome Web Store)
  • Consulting: Do This in SAS? (Google Play)
  • Consulting: How Do You Do This in SAS? (Amazon Appstore and Chrome Web Store)

All these apps are updated frequently, and the paid-for apps are priced at less than US$3 based on the number of questions that are answered, and within the apps you can ask new questions that can be added in future updates. It doesn’t matter which platform you use, as the same content is present in the corresponding Google Play, Amazon Appstore and Chrome Web Store apps.

Data Steps section of my SAS course is nearing completion

Loading

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.