Fancy a 1-to-1 chat about a SAS-related topic?

Loading

Now that I have Mondays free from client-related contracts, I am able to do whatever I want, such as work in my garden, read books, write my own books and articles, develop apps and other software applications, or even give SAS training! So, to help you book 1-hour 1-to-1 training sessions with me to talk about the SAS topics of your choosing, I have created a SAS training session booking calendar.

Training sessions will be provided using Google Calendar and Hangouts, and cost GBP100.00 for each hour. The booking form allows you to copy in your chosen SAS-related topics from the list provided, and then we get together at the selected time for an hour of discussion around that topic, so you will be able to ask me any questions you need answering to learn more about SAS software. The topic selection allows me to prepare demonstrations and information specifically for the session, and other topics will be added to the list over time.

Note that I will only send out one Google Calendar invite, but, if you want to have some friends and colleagues around to join in, then that will be just fine.

SAS, Book, Rocks and the Passing of Time in Colorado

Loading

SAS Global Forum 2018 was held in the Colorado Convention Center from April 8 to 11 (Sunday to Wednesday) in Downtown Denver.

Attending a large SAS conference like SAS Global Forum, with its 5,500 attendees, you have to be prepared to “think on your feet”, because nothing ever happens quite the way you expect it to, and finding a specific attendees requires luck and/or persistence. That said I found 60+ friends and contacts during the conference, from as far afield as Australia and the UK, and even met a friend in Denver airport on my way home!

It might be of interest to you that, even though many of the sessions were looking at the newest SAS products and features, including SAS/Viya, attendances generally appeared to be higher in the sessions involving SAS programming. In each session head counts were recorded, so the conference organisers will hopefully be able to see this for themselves. I presented “The Art of Defensive Programming” on the Tuesday afternoon to a full room of 148 seats, and with a queue of hopeful attendees outside. I was told afterwards that the room limit was 144, but 4 seats had been added before I started to present!

However, I would like to apologise to anyone who attended my paper and was disappointed that my 50-minute paper only lasted 20 minutes. I was making use of the new count-down timer on the desk, which told me how long I had to go, and then had amber and red lights to tell me when I had 5 minutes left and when I had to stop. Unfortunately I didn’t notice that the starting time had been set to 20 minutes, instead of 50 minutes, and nor did the room chair. If there are time left cards, or count-down timers, then I do tend to rely on them, rather than using my own watch, or the room clock (which I couldn’t see in that room anyway). Whenever I present I have specific slides which I use to check how fast, or slow, I’m going, and at the first of these slides I saw I only had 10 minutes left, so I upped my pace. However, I can assure everyone that I didn’t remove any of the content, even though I finished on 20 minutes to the second! I just cut back on the explanation I would have added to each slide, which could have extended my presentation to 50 minutes. Had the room chair or I known that there had been a queue outside, then I could have re-run my presentation in the 30 minutes I had left, so that no-one who wanted to attend would have missed out. But hindsight is a wonderful thing!

During the conference I ran a free prize draw at the ODS Graphics booth to win a copy of my latest book “SAS Programming and Data Visualization Techniques“. I set up the draw on the Sunday afternoon with a printout of the book’s cover and contents, a pile of cards for the entrant’s name and email address, and a box to put the completed cards. Unfortunately the cleaning team in the Quad were super-efficient, and on Monday morning the box with the completed cards from Sunday had gone! I had to borrow a plastic bowl from SAS Publishing for the completed cards, and hope that the cleaning team would ignore it. Anyway by 4pm on Tuesday the bowl was still there with 22 entry cards (although I’d had to replace the printout of the book’s cover and contents on Tuesday morning!), and Christine Grice’s card was drawn by Sanjay Matange. I arranged for an announcement to be made over the public address system, and I contacted Christine using email and the SASGF app, but was unable to find her during the conference. Happily though, since the conference, we’ve been in touch, and she now has copies of the 2 self-published ebooks that were included in my latest book.

After the conference my wife Angela and I went on a day tour into the nearby Rockies, visiting the Red Rocks Amphitheater, where the Beatles, John Denver and Widespread Panic had performed. We also visited several mining towns. Thursday was a very warm day in Denver with temperatures reaching 27C (81F), and Angela and I walked to the Denver Botanic Gardens in the afternoon. Friday, however, was not at all warm, with Denver reaching 6C (43F), but Central City in the Rockies reaching -3C (27F)! Idaho Springs was warmer at 0C (32F), but there was still a frozen waterfall there.

Did I enjoy the SAS Global Forum? Yes!

Did I enjoy exploring Denver and the Rockies? Yes, and I tasted 25 local beers while I was there too!

Would I come back? If I had the opportunity to present in Denver again, then Yes!

I’m not planning to attend the SAS Global Forum 2019 in Dallas, unless I’m invited to run a SAS training course alongside the conference, but I will be at PharmaSUG 2019 in Philadelphia, which will be my first time at PharmaSUG! I’m hoping to run a training course before or after the conference, and present at the conference too. Hopefully I’ll be able to meet you there (and I’ll be bringing my own clock!).

Want to see issue 56 (and beyond) of VIEWS News? I need 100+ to sign up!

Loading

I have reported that the VIEWS web site had been closed down, and although the newsletter archive is still available on sasCommunity.org, that site is now read-only prior to being decommissioned. However, I have stored all 55 of the original VIEWS News PDF files on my blog site, which can be accessed via the VIEWS UK forum. This forum is available on request to all registered blog members, and those with access will be notified of any new content. The issues include the following features:

  • Ask the Expert
  • Did You Know?
  • Formats, Options & Functions
  • SAS News, Events and Reports

Some of the new content will include previously unpublished indexes I used to help me write the Formats, Options & Functions articles in the newsletters, which allowed me to see in a single view which features had already been described and when. I will also be including an authors list soon. All features that could help you find information that is difficult to find using standard searches. You also need to know that I intend to publish some new issues of VIEWS News too, but only if 100+ members request access to the VIEWS UK forum.

You might be thinking that, as I had emailed VIEWS members in the past, I could use that email list to include them automatically again. However, this new VIEWS environment has been built on an existing blog site, and, although theoretically I could register all the previous VIEWS members using their email addresses, I don’t know all of their real names and would, therefore, have to guess their new user names, so I don’t think forcing anyone to register on my blog site is at all appropriate. This is the reason I’m asking everyone interested to register themselves instead.

So, whether you have been a VIEWS member in the past, or not, here is how you can join the new VIEWS UK forum:

  1. If you are not already registered on my blog site, then join via the registration page.
  2. Once you have registered, then email views-uk@hollandnumerics.org.uk, or use the site’s Contact Us link, to say you would like to join the VIEWS UK forum.
  3. I will manually update your blog profile to give you the required configuration and reply to your registered email address as soon as you have access to the new forum. You will then see VIEWS UK in the forum list when you next log into the blog site.

Note that, as I write this post, a total of 69 members now have access to the forum. If you’ve not yet requested access, then only 31 more members are required to give me the impetus to publish more VIEWS News issues!

I’ve added the final topic of the Data Steps course in the SAS course (in the SAS Programming Forum)

Loading

I’ve added the final topic of the Data Steps course in the SAS course (in the SAS Programming Forum), and it describes some of the syntax used in Data Step processing.

I have added, for those who don’t want to follow the course but would prefer to read the course notes, a copy of course notes as a downloadable PDF ebook, and I have now published Android ebook apps with the same content on Google Play and Amazon Appstore.

As other SAS courses are finalised I will be publishing them as PDF ebooks and Android apps too.

I’ve added the final topic of the PROC SQL course in the SAS course (in the SAS Programming Forum)

Loading

I’ve added the final topic of the PROC SQL course in the SAS course (in the SAS Programming Forum), and it describes some of the limitations and differences between the SQL language in PROC SQL and the ANSI (American National Standards Institute) guidelines for SQL.

I’ve also added, for those who don’t want to follow the course but would prefer to read the course notes, a copy of course notes as a downloadable PDF ebook, and have published Android ebook apps with the same content on Google Play and Amazon Appstore.

As other SAS courses are finalised I will be publishing them as PDF ebooks and Android apps too.

The SAS Programming Forum is growing again with 8 new SAS course topics

Loading

The SAS course and the SAS Programming Forum continue to grow, I have just added 8 new course topics about PROC SQL, and there are now 33 topics in 4 different sections:

  • [A] SAS components – 2 topics
  • Data Steps – 13 topics
  • [F] PROC SQL – 14 topics (8 new topics!)
  • [G] Macros – 4 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!

Maybe my last report from a PhUSE event: Beerse Single Day Event 2017

Loading

Last month I talked about the presentation “The Art of Defensive Programming – Coping with Unseen Data” I was doing at the PhUSE Single Day Event (SDE) in Beerse, Belgium. The event was held yesterday on 28 November 2017 at the Janssen EMEA site, where I’d started my SAS contracting activities 25 years earlier. This was the 6th SDE I’d presented at in Belgium, and the 3rd on this site, so I was fairly familiar with the venue and knew many of the attendees too.

As at recent conference events I included a free draw for a copy of my latest book “SAS Programming and Data Visualization Techniques“. The attendance at the SDE was around 80 and not just coming from Belgium, with 21 of those entered the draw, and the winner was Lieke Gijsbers from OCS Consulting in the Netherlands (see me presenting her with my book in the photo).

You are probably now asking why this will be my last report from a PhUSE event? Over the last year or so I have reviewed the benefits I get from presenting at conferences and how much it costs me to attend them. Consultants spend a lot of time doing Cost-Benefit analyses and PhUSE events seemed to be moving lower down the list. The larger companies can easily afford to send multiple delegates, but a small percentage of their staff, to PhUSE events because of economies of scale. Unfortunately, Holland Numerics is not a large company, so we have to send 100% of our staff (me!). By presenting we get a 33% reduction on the full conference fee, but we lose 100% of our income during the conference and SDE days, and the same is true for every other independent consultant attending PhUSE. Next year I was hoping to combine some of my training courses with PhUSE SDE and PhUSE Connect (the new name for the annual conference!) events, but none had come to fruition.

I am extremely happy with the records I have created as a mere SAS programmer (and not a Statistical Programmer!) during my membership of PhUSE:

  1. I have attended 13 consecutive PhUSE annual conferences since the first was held in Heidelberg in 2005.
  2. I have presented at least 1 paper in every PhUSE annual conference I have attended, including several papers I had brought with me “just in case” to fill in for short-notice withdrawals.
  3. I have presented in 18 SDEs since they started in 2008, including 6 in Belgium, 4 in the UK, 3 in Germany, 2 in Switzerland and Denmark, and 1 in the Netherlands.
  4. Since the PhUSE annual conference was held in Basel in 2009, I have held a beer-tasting evening near to the conference. That is a total of 9 beer-tasting evenings! It started because I wanted to taste the local beers, I preferred to drink beer with friends, and it seemed to work out just fine, because I had no complaints, and I added many new beers to my beer-tasting database. In fact I had to stop Yvonne Moores, the 2011 Brighton conference chair, from putting a note in the daily conference news, and it was still over-subscribed using just word-of-mouth! The largest evening attendance was actually 24 in Budapest, when, unable to find a Hungarian beer establishment, I opted instead for the “Belgian Abbey Restaurant”!
  5. Last, but not least, no-one has enjoyed PhUSE events more than me!

I would like to thank PhUSE for allowing me to present my SAS-related papers at their conferences and SDEs, but I will not be renewing my membership of the PhUSE Society as usual in January.

Are you interested in SAS macros or SAS efficiency? I’ve updated both apps in Google Play and Amazon Appstore

Loading

Are you interested in SAS macros or SAS programming efficiency? I’ve updated my Android apps focusing on both these topics in Google Play and Amazon Appstore.

Are you going to the PhUSE Belgium SDE (Single Day Event) in Beerse? I’m presenting there!

Loading

The PhUSE Belgium SDE is being held at Janssen Pharmaceutica near Beerse again on Tuesday 28th November 2017, where I’ll be presenting “The Art of Defensive Programming – Coping with Unseen Data” at 1600hr.

I hoping to be able to run a free prize draw there for you to win a copy of my recent book “SAS Programming and Data Visualization Techniques: A Power User’s Guide“. Just drop in a business card or fill out a blank card at the event to get a chance to win a copy.

I’m looking forward to revisiting the site where I worked on my very first SAS contract in 1992, and maybe tasting some interesting Belgian beers too!

Hope to see you there.

Are you going to SAS Global Forum in Denver? I’m presenting there!

Loading

SAS Global Forum is being held in Denver in 2018 from Sunday 8th to Wednesday 11th April, and I’ve been invited to present “The Art of Defensive Programming: Coping with Unseen Data” there.

I’m also hoping to run another prize draw again for you to win a copy of my latest book “SAS Programming and Data Visualization Techniques: A Power User’s Guide“. Just drop in a business card or fill out a blank card at the ODS Graphics stand to get a chance to win a copy.

Note, however, that at SASGF18 you will only be able to read a copy of the book contents at the stand, as during SASGF17 someone took away my well-used sample copy. So, if you still want to browse the sample, then you’ll have to find me among the expected 5,000+ attendees! 🙁

Hope to see you there.

There is a new SAS Training Course list for 2017Q4

Loading

There is now a new Training Course list for 2017Q4, which can be downloaded from here. The courses available in 2016 and early 2017 are still there, but had added a new course to the list:

  • ½ day Defensive SAS Programming training

I’m also 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

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

My blog and forums are open for business in their new premises!

Loading

On 28 March 2017 I completed the migration of my blog and forums to a new server. You will not have to do anything different to access the new server, as it is all managed transparently by my router.

The new environment is protected by an uninterruptible power supply, and has an increase in its available disk space. I’m hoping that the chance of future interruptions has been dramatically reduced.

Alongside the blog are 2 forums where you can ask questions:

(1) The SAS Skills Discussion Forum is included when you register for the Free membership, and is where you can ask questions about SAS skills, but not SAS coding problems.

(2) The SAS Programming Forum, which has a very small subscription cost, is where you can ask SAS coding questions, including those from homework and interviews. This forum also includes a growing SAS course in the form of small topics. There are currently 3 main sections to the SAS course: Data Steps, PROC SQL and macros, but more are being developed.