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!

How has 2020 gone so far?

Loading

I had a number of plans at the beginning of 2020, so how are they doing so far:

  • February 2020: Publish VIEWS News issue 59. Follow the link to learn how to get free access! – Published in early March 2020.
  • March/April 2020: Present a paper at SAS Global Forum (SASGF) in Washington DC – Conference cancelled due to COVID-19. However, my paper “How Many Shades of Guide: SAS Enterprise Guide to 8.1 and SAS Studio to 3.8 with SAS 9.4” will still be published here on my blog site.
  • May 2020: Publish VIEWS News issue 60. Follow the link to learn how to get free access! – Still OK.
  • July 2020: See the Oberammergau Passion Plays in Germany, which occur only every 10 years!
  • August 2020: Present a paper and SAS training seminar at PharmaSUG China in Shanghai – I pulled out due to COVID-19 concerns in China.
  • August/September 2020: Publish VIEWS News issue 61. Follow the link to learn how to get free access! – Still OK.
  • November 2020: Publish VIEWS News issue 62. Follow the link to learn how to get free access! – Still OK.

VIEWS News 59 (2020Q1) has been published!

Loading

VIEWS News issue 59 has been published today.

Articles in this issue are by LeRoy Bessler (ODS Graphics procedure), Scott Thomson (Analytics environment), and myself (SAS macros). I’ve also added more interesting/useful formats, options and functions, and future SAS-related events.

If you would like to contribute an article on any SAS topic, or a SAS-related event date from June 2020 onward, to the next issue in May 2020 then please send an email with a description/attachment of your contribution to view-uk@hollandnumerics.org.uk or phil@hollandnumerics.org.uk.

To be able to read this and all previous issues you will need to follow these steps:

  1. If you have not already registered on this blog site, go to blog.hollandnumerics.org.uk and register for free membership.
  2. Once successfully registered, click the menu item [Subscriptions for Forums and Features] > [Request access to the VIEWS UK forum] to request free access to the VIEWS UK forum, then add your name and email address to the form before clicking [Send].
  3. On receipt of a request for an existing blog member I will register them for free access to the VIEWS UK forum, and then send them an email to confirm this.
  4. The next time they log onto the blog site they will see VIEWS UK in the forum list, where you will find the latest issue of VIEWS News, forum topics to find the backissues, functions and formats in every published issue, and a tag cloud covering every forum on the site to which you have access, including VIEWS UK and the VIEWS News issues.
  5. They will also be automatically informed of any VIEWS UK updates.

Enjoy!……………..Phil

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’m presenting “How Many Shades of Guide: SAS Enterprise Guide to 8.1 and SAS Studio to 3.8 with SAS 9.4” at SAS Global Forum 2020 in Washington DC

Loading

I’m presenting “How Many Shades of Guide: SAS Enterprise Guide to 8.1 and SAS Studio to 3.8 with SAS 9.4” at SAS Global Forum 2020 in Washington DC from 12:30pm to 1:30pm on Wednesday 1st April.

I’ve been using EG since 2001 when the version was 1.1.1, so I thought it would be a good idea to gather together all my EG and SAS Studio conference presentations with their assorted screenshots, and try to explain why each application works the way it does. In fact my EG installation has been updated since my paper was accepted, so I’ll actually be talking about EG 8.2 too!

I know some of you who are planning to attend SASGF 2020 may be thinking about starting their journeys home before my presentation starts. I would like to see everyone in the audience, but I do understand the pressures of transportation around DC, so, for you and anyone who can’t attend, I’ll be in a live-streaming session. Hopefully my session will also be recorded, so anyone who wants to learn more about EG and SAS Studio can watch me later.

For those of you who are attending SASGF please look out for me in the Quad, and elsewhere in the conference, and say Hi! I’ll try to post a link to my session here after the conference finishes (assuming it is recorded, of course!).

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