New advice when registering as a blog member


Remember to use your full personal name, not a business name (unless you’ve asked me first), and a full last name is expected and required to complete registration, not “X Y” where your user information is considered to be hiding your identity. If you supply a name like “X Y” then your profile will be set to Pending, which will be deleted automatically after 1 month if not corrected.

NEW: An activation email will be sent to your registered email address to confirm that it is valid. If you do not receive it within a few minutes, then please contact Philip Holland at, as your email address may not have been accepted, but can be corrected.

It is also recommended that you do not use an email address as, or include your company name in, your user name, because user names cannot be changed, but your email address or company might change in the future!

You can register for Free blog membership here: Join Now Button

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


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
  2. Emails will now be sent from
  3. Hopefully emails will be sent more reliably

If you have existing email filters that accept emails from, please can you add 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

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

The VIEWS web site has closed down forever!


Many of you may be asking what is “VIEWS”?

Back in 1998 a group of enthusiastic SAS programmers founded VIEWS – the International SAS Programmer Community, and Andy Radcliffe became the first editor of VIEWS News. The free newsletter delivered hints, tips, news, and features on technologies and techniques to VIEWS members. Articles were written by a balanced mixture of users and consultants – with occasional contributions from SAS staff too. The short, punchy style of VIEWS News made it easy and convenient to read for the busy members of VIEWS. I took over the Editor’s role in 2002, and published it up to the most recent issue in 2011 Q4. Every back-issue of the newsletter can still be downloaded from here, because the newsletter continues to be hosted on

Actually the newsletter has not really died yet, but is in suspended animation until I have time to publish a new issue, but the VIEWS web site and email addresses have now expired, so I have created a new contact email address for VIEWS at, which will accept membership requests and newsletter content, just in case. More details can be found in this post: Rejoining VIEWS UK (or just joining for the first time)?.

Skills needed by a good SAS programmer apart from programming


You have a certificate from SAS saying you can program, and you have been offered a job as a SAS programmer. Well done! So what happens now?

Hopefully your new employer will arrange for SAS training for you, and then you’ll be given a computer to run your SAS programs on. If you are lucky you’ll be in a team of SAS programmers where some are experienced enough to assist you. However, your team may only include inexperienced programmers like yourself, so how do you get answers to your questions?

(1) Research: Search Google for possible answers to your questions. This may produce links to or, so try these links first.
(2) Experiment: Try out these suggestions to see which work for your situation.
(3) Discuss: Talk about these solutions with your colleagues.

Do not:
(1) Delegate: Post vague questions on forums in the hope that someone will write your program for you. You will never improve your skills by using someone else to do it for you.
(2) Break copyright: Post any company data on the web or in external emails.
(3) Reveal: Ask questions on the web which may reveal confidential information about your employers or clients. It is also recommended that you never post your email address or phone number either, because they could be used to spam you, or even to spam others looking as if you are doing it.

Once you have a working SAS program, and this may take a while to achieve, remember to re-visit it regularly with a view to improving it using knowledge you’ve gained over time. No program is ever perfect, but your aim should be to approach perfection with each amendment.

So how do you gain SAS knowledge? The SAS certification questions and answers cover only a tiny fraction of what SAS can do. The temptation is to stick to what you know, but this will never allow you to improve your SAS programming, so read the SAS blogs, SAS-related forums and SAS conference papers regularly, and then try out the new techniques to learn new stuff all the time. This should never end. I’ve been using SAS since 1981 and I’m still learning new stuff about SAS every day!

Where did you hear about this Blog site?


In order to determine the best way to advertise this Blog and Forums site, like all data analysts, I need to collect together some data to analyse. This is why I’ve created the poll below, so I hope you will help me by voting. Note that you will be able to vote for more than one option, so you shouldn’t have to decide between them.

Where did you hear about this Blog site?

  • LinkedIn: SAS Professional Forum (37%, 10 Votes)
  • LinkedIn: SAS Author: Philip R Holland (22%, 6 Votes)
  • None of these (11%, 3 Votes)
  • LinkedIn: SAS Freshers (7%, 2 Votes)
  • LinkedIn: sasCommunity (4%, 1 Votes)
  • LinkedIn: SAS University Edition (4%, 1 Votes)
  • Google+: SAS Professional Forum (4%, 1 Votes)
  • Twitter (4%, 1 Votes)
  • Email from friend or colleague (4%, 1 Votes)
  • Web search (4%, 1 Votes)
  • LinkedIn: from Pulse, from status or in another group (0%, 0 Votes)

Total Voters: 19

Loading ... Loading ...