SAS training for home-workers: Keeping your mind active and your skills current

Loading

I have been working from home on and off since 1996, so it now feels quite normal to start my work day by walking from my kitchen into my office. I know some of my colleagues have struggled with the many distractions that exist at home, so I suppose I’ve been lucky, but I still do not like doing nothing at all. To stop any boredom setting in I will look for ways to do something useful, and, over the years, I have taught myself many programming languages by reading books, running example code, and trying to write applications that will be useful day-to-day, for example:

  • Database applications for calculating hours left to work and printing invoices in Visual Basic.
  • Web applications to send me emails and SMS messages in Perl.
  • Smartphone apps for webOS (remember HP/Palm phones?) in Javascript and HTML5.
  • Smartphone apps for Android in Java.
  • Crossword puzzle word-finder scripts in LibreOffice Basic.
  • SAS Enterprise Guide custom tasks in VB.Net.
  • SAS Studio custom tasks in XML.

Each language presents a different set of problems and solutions, so each new solution will broaden your knowledge of the computer world. Not all language have been central to my day job, but my views on solving computer problems has been moulded by each new programming language I’ve used. In 1996 there was no significant online help, so you couldn’t easily ask anyone for help, but instead you had to rely on hints and tips in computer magazines. Later the online communities have become vital, but you will now have to ask your questions in the correct way, so that it will be understood by each community, as names are not necessarily consistent, otherwise your question is likely to be ignored. I’ve now found ways to improve the chances of my questions being answered, even if my problems are not always resolved:

  • Write a subject line that asks a question that could be answered, otherwise it probably won’t even be read.
  • Set the scene by describing the environment you are working in, such as operating system, and software language and version.
  • Describe in as much detail as you can what you are trying to do, what you have already tried, and any results/messages that you are getting, even if you don’t understand them.
  • Never assume that you’re problem can be solved, but work with anyone who offers you assistance.
  • Be humble and grateful, because there will be programmers out there who know more about this than you, and you might need to call on their skills again.

So what has all this got to do with SAS training? Well, thanks to COVID-19, there are now more home-workers than ever before, and in some cases the work available may not be filling your day, so what can you do to fill your spare time and improve your programming knowledge? I have gathered together some sources of SAS training and information which are either free or inexpensive, which you may find useful, and if you find out about any more, then post a comment and I’ll be happy to check them out:

  • Training courses:
    • My corporate SAS training courses are intended for large groups, but each course has an associated eBook that is much cheaper and available through the Training section on this site.
    • I have a low-cost forum with a monthly subscription called the SAS Programming Forum, which welcomes SAS programming questions, but also includes the SAS course with a growing number of SAS-related topics, such as Data Steps, SAS Macros and PROC SQL, either as individual posts or LMS courses.
    • If you prefer to learn from eBooks or Android apps, then the topics in the SAS course are also available as eBooks and Android apps (on Amazon Appstore and Google Play).
  • Papers and books:
    • The Conferences Paper section on this site is filled with papers covering a wide range of SAS-related topics, which can be downloaded for free.
    • Other SAS-related books can be bought through the Books section on this site.
    • The largest searchable collection of SAS-related conference papers is maintained by Lex Jansen, including papers from SUGI, SeUGI, regional SAS user groups and forums, VIEWS, PhUSE, PharmaSUG and SAS Global Forum.
  • Competitive learning:
    • Sasensei is a SAS-related quiz and learning site where the flashcards, questions and quizzes are contributed by the users, and you earn points and awards from contributions and correct answers, but you will always learn from your incorrect answers too.
  • SAS support:
  • SAS programming platforms for learning:
    • SAS University Edition is free for use as a learning platform, and can either be downloaded and installed on your laptop using VMware or VirtualBox, or accessed through the web on the AWS Cloud.
    • WPS Analytics Community Edition is a free version of WPS Analytics, which can be licensed from World Programming for 6 months at a time and installed on your PC, and can run SAS programs using quite a large subset of SAS programming features, and includes R and Python interfaces.

I think that should at least get you started on your SAS improvement projects!

The SAS Programming Forum has been growing again with new SAS course sections and topics

Loading

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

The SAS course and the SAS Programming Forum continue to grow, I have just added some new course sections and topics about Data Steps, Base SAS Procedures, PROC SQL, SAS Macros, SAS Enterprise Guide and SAS Studio, and there are now 54 topics in 7 different sections:

  • A. SAS components – 2 topics
  • B. Data Steps – 14 topics (1 new topic)
  • C. Base SAS Procedures – 6 topics (new section)
  • F. PROC SQL – 15 topics (1 new topic)
  • G. SAS Macros – 15 topics (11 new topics)
  • N. SAS Enterprise Guide – 1 topic (new section)
  • O. SAS Studio – 1 topic (new section)

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 the final topic of the SAS Macros course in the SAS course (in the SAS Programming Forum)

Loading

I’ve added the final topic of the SAS Macros course in the SAS course (in the SAS Programming Forum), and it describes some of the syntax used in SAS Macros 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.

Please enjoy if you’ve subscribed to the SAS Programming Forum.

SAS-related Jobs from Recruiters in UK and US in March 2020

Loading

Looking for a SAS-related job?

There are a number of SAS-related jobs in the SAS Jobs Listing this month in the UK and US, and the links are open to all site visitors:

  • UK: Pharmaceutical permanent positions from SQN Recruitment.
  • UK: Pharmaceutical contract positions from Pop-Science.
  • US: IT contract-to-hire and contract positions from Pinnacle Solutions.

Please use the links in the job listings to apply for these positions.

Recruiters

I’m always looking for new recruiters to post SAS-related jobs on this site covering India, UK, the Americas, Europe and the Rest of the World. In particular, I would like to include jobs in Europe and India, where nearly half of the registered blog members are located, but currently there are no active recruiters for them.

If you have a regular supply of jobs, then there is a free trial which is open to all recruiters, but with 2 simple rules:

  1. The free trial will be extended by an additional calendar month only when a job is posted, and will expire automatically if no job has been posted in a calendar month.
  2. The posted jobs must be SAS-related.

The current regional breakdown of registered blog members is as follows, but note that the SAS Jobs Listing is open to all site visitors:

  1. Indian sub-continent: 33.4% (215)
  2. The Americas: 23.4% (151)
  3. UK: 21.6% (139)
  4. Europe: 15.1% (97)
  5. Rest of the World: 6.5% (42)

I’ve added 5 more topics to the Macros course in the SAS course (in the SAS Programming Forum)

Loading

I’ve added 5 more topics to the Macros course in the SAS course (in the SAS Programming Forum), and they describe more of the syntax used in SAS macro programming.

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

The Macros book and apps will be published after I’ve added the final topic, and as other SAS courses are finalised I will be publishing them as PDF ebooks and Android apps too.

SAS-related Jobs from Recruiters in UK and US in February 2020

Loading

Looking for a SAS-related job?

There are a number of SAS-related jobs in the SAS Jobs Listing this month in the UK and US, and the links are open to all site visitors:

  • UK: Pharmaceutical permanent positions from SQN Recruitment.
  • US: Pharmaceutical contract-to-hire and IT contract positions from Pinnacle Solutions.
  • US: Pharmaceutical permanent positions from Covance.

Please use the links in the job listings to apply for these positions.

Recruiters

I’m always looking for new recruiters to post SAS-related jobs on this site covering India, UK, the Americas, Europe and the Rest of the World. In particular, I would like to include jobs in Europe and India, where nearly half of the registered blog members are located, but currently there are no active recruiters for them.

If you have a regular supply of jobs, then there is a free trial which is open to all recruiters, but with 2 simple rules:

  1. The free trial will be extended by an additional calendar month only when a job is posted, and will expire automatically if no job has been posted in a calendar month.
  2. The posted jobs must be SAS-related.

The current regional breakdown of registered blog members is as follows, but note that the SAS Jobs Listing is open to all site visitors:

  1. Indian sub-continent: 33.0% (209)
  2. The Americas: 24.0% (152)
  3. UK: 21.5% (136)
  4. Europe: 14.8% (94)
  5. Rest of the World: 6.6% (42)

VIEWS UK forum now has VIEWS News indexes for SAS Formats & Informats, Functions and Options

Loading

Please note that all of the links relating to VIEWS News and the VIEWS UK forum require you to have already logged onto the blog site, and have also requested free access to the VIEWS UK forum!

VIEWS UK forum has VIEWS News indexes for SAS Formats (& informats), Functions, and now Options (new!) too. These indexes cover every issue of VIEWS News, and links to these indexes can also be found on the individual VIEWS News issue pages.

There is also a Forum Tag Cloud for logged on users covering all of your registered forums. However, please note that the VIEWS UK forum is currently missing issues 47-55, which will have been added in time for the February issue of VIEWS News.

Don’t forget to log on and request access to the VIEWS UK forum first, and then click these links!!

Blog member Laura Illingworth is presenting at the SUGUKI meeting in London on Feb 6

Loading

London SAS Meetup

The Hub @ SAS London, 7th Floor, 199 Bishopsgate, London EC2M 3TY

Details

• 18:00 – Arrive
• 18:30 – “Missing data and how to use multiple imputations to improve models” by Laura Illingworth
• 18:50 – Sasensei Quiz Break
• 19:00 – “Hidden Gems in SAS Enterprise Guide” by Peter Hobart
• 19:20 – Wrap up and drinks
• 20:00 – Vacate to a local watering hole

Entrance is free but you must RSVP to confirm attendance for security/capacity reasons.

STOP PRESS: I’ll be presenting “Writing Reusable Macros, Part 1: Managing Data Sets” at the SUGUKI Lunch & Learn on Friday 10 January @ 1210 (GMT)

Loading

STOP PRESS: I’ll be presenting “Writing Reusable Macros, Part 1: Managing Data Sets” at the SUGUKI Lunch & Learn on Friday 10 January @ 1210 (GMT).

Please use this link to join me on Friday!

SUGUKI Lunch & Learn

SAS-related Jobs from Recruiters in the US in January 2020

Loading

Looking for a SAS-related job?

There are a number of SAS-related jobs in the SAS Jobs Listing this month in the US, and the links are open to all site visitors:

  • US: IT contract and pharmaceutical contract-to-hire positions from Pinnacle Solutions.
  • US: Pharmaceutical permanent positions from Covance.

Please use the links in the job listings to apply for these positions.

Recruiters

I’m always looking for new recruiters to post SAS-related jobs on this site covering India, UK, the Americas, Europe and the Rest of the World. In particular, I would like to include jobs in Europe and India, where nearly half of the registered blog members are located, but currently there are no active recruiters for them. In fact, if you have SAS jobs located anywhere in the world, and no jobs for that location can be found in the SAS Jobs Listing, then please contact me, as I can get your jobs seen!

If you have a regular supply of jobs, then there is a free trial which is open to all recruiters, but with 2 simple rules:

  1. The free trial will be extended by an additional calendar month only when a job is posted, and will expire automatically if no job has been posted in that calendar month.
  2. The posted jobs must be SAS-related.

The current regional breakdown of registered blog members is as follows, but note that the SAS Jobs Listing is open to all site visitors:

  1. Indian sub-continent: 32.9% (208)
  2. The Americas: 24.1% (152)
  3. UK: 21.4% (135)
  4. Europe: 15.2% (96)
  5. Rest of the World: 6.5% (41)

Microsoft Exchange 365 is dead! Long live Google Mail! …but maybe not!

Loading

I’ve finally realised that my company’s email server on Microsoft Exchange 365 is too unreliable to use for emails from my SAS blog server, so I have configured the email client to send emails through Google Mail instead. This means that:

  1. Emails will no longer be sent from phil@hollandnumerics.com
  2. Emails will now be sent from hollandnumerics1992@gmail.com
  3. Hopefully emails will be sent more reliably

If you have existing email filters that accept emails from phil@hollandnumerics.com, please can you add hollandnumerics1992@gmail.com to your accepted email addresses.

In case you are wondering why I phrased the title of this post as I did, it is based on the announcement from Buckingham Palace when a monarch dies and the succession of a new monarch to the throne of the United Kingdom. It is a statement of continuity!

Stop Press

Various attempts to send out emails to members have made me realise that the reliability of the Microsoft Exchange 365 servers is better than the traffic restrictions of the Google Mail servers. As a consequence I’ve decided to revert back to sending emails from phil@hollandnumerics.com.

However, I may make use of the email server on my hollandnumerics.org.uk server in the future, so watch this space!

SAS-related Jobs from Recruiters in UK and US in December 2019

Loading

Looking for a SAS-related job?

There are a number of SAS-related jobs in the SAS Jobs Listing this month in the UK and US, and the links are open to all site visitors:

  • UK: Pharmaceutical permanent positions from SQN Recruitment.
  • US: IT contract-to-hire positions from Pinnacle Solutions.
  • US: Pharmaceutical permanent positions from Covance.

Please use the links in the job listings to apply for these positions.

Recruiters

I’m always looking for new recruiters to post SAS-related jobs on this site covering India, UK, the Americas, Europe and the Rest of the World. In particular, I would like to include jobs in Europe and India, where nearly half of the registered blog members are located, but currently there are no active recruiters for them.

If you have a regular supply of jobs, then there is a free trial which is open to all recruiters, but with 2 simple rules:

  1. The free trial will be extended by an additional calendar month only when a job is posted, and will expire automatically if no job has been posted in a calendar month.
  2. The posted jobs must be SAS-related.

The current regional breakdown of registered blog members is as follows, but note that the SAS Jobs Listing is open to all site visitors:

  1. Indian sub-continent: 33.2% (200)
  2. The Americas: 24.2% (146)
  3. UK: 21.2% (128)
  4. Europe: 14.8% (89)
  5. Rest of the World: 6.6% (40)