Articles in this issue are by Jonathan Boase (SAS performance), Laura illingworth (SUGUKI report), 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 March 2020 onward, to the next issue in February 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:
If you have not already registered on this blog site, go to blog.hollandnumerics.org.uk and register for free membership.
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].
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.
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.
They will also be automatically informed of any VIEWS UK updates.
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:
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.
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:
I am an independent SAS consultant and have been working through my own company, Holland Numerics Limited, since 1992. In the UK the vast majority of IT contractors use Limited companies when working for other companies, which protect both the contractors and their clients. Contractors also benefit from the clients paying their company, and then the company paying them, so there can be tax and National Insurance savings. This has been seen by Labour and Conservative governments as tax avoidance, and the Labour government introduced IR35 legislation in 2000 to restrict these benefits for contractors who are also company directors when they were only working for a single client, labelled as “deemed employees”. This forced contractors to pay the same tax and National Insurance as permanent employees, but without any employee benefits.
It should be noted here that permanent employees receive a number of benefits as part of their employment, but contractors have to pay for these themselves:
payroll processing, including tax and National Insurance payments
pension payments
employer National Insurance contributions
business-related insurance
travel expenses
conference attendance fees
equipment purchase
office facilities
Until now the responsibility of stating whether a contractor is inside or outside IR35 and paying the correct tax and National Insurance payments has been with the contractor’s company, but the reforms move these responsibilities to the client (determining IR35 status) and agency (paying the correct tax and National Insurance payments). Some companies have already decided to set the IR35 status of all of their contractors to inside, including Lloyds Bank, Barclays and GlaxoSmithKline, making them “deemed employees”. The following article describes the issues of this reform for contractors and companies:
There is now a question about what can contractors do to stay outside of IR35, and then persuade their clients not to state that they are inside. I can’t claim to be an expert on this subject, but I can suggest some organisations who are much better qualified to answer this question. The following links will help to explain the problem and possible solutions:
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:
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.
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:
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 and contract positions from SQN Recruitment and Aerotek.
US: Financial and IT contract-to-hire 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:
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.
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:
VIEWS News issue 57 has been published today. To be able to read this and all previous issues you will need to follow these steps:
If you have not already registered on this blog site, go to blog.hollandnumerics.org.uk and register for free membership.
Once successfully registered, reply to the registration confirmation email, and ask me to give you free access to the VIEWS UK forum.
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.
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.
They will also be automatically informed of any VIEWS UK updates.
VIEWS News 57 will be published on September 16. This will be the 2nd issue in 2019, and the SAS world is changing, but still retaining it roots in Base SAS programming at the same time.
Articles in this issue are by LeRoy Bessler (ODS Graphics), Allan Bowe (web apps), and myself (SAS macros and my PharmaSUG US report). 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 December 2019 onward, to the next issue in November 2019 then please send an email with a description/attachment of your contribution to view-uk@hollandnumerics.org.uk or phil@hollandnumerics.org.uk.
Apologies for the 9 hour server outage on my SAS-related blog site today, but I now know more about the relationships between Apache and PHP:
The server’s Ubuntu operating system was upgraded from 16.04 to 18.04 on 18Aug2019.
The Apache WordPress server was unaffected, but my Apache cloud server refused to start due to a PHP incompatibility.
The cloud server software was then upgraded to use PHP7.2 instead of PHP7.0, but the server still refused to start.
More PHP7.2 modules were downloaded and installed.
The PHP configuration in the Apache cloud server was changed from PHP7.0 to PHP7.2, and it now started.
At some point in the updates the listening ports on the Apache WordPress server were also updated, so, when it was automatically restarted at midnight, it immediately failed due to duplicate ports.
Finally, this morning, I corrected the listening ports on the Apache WordPress server, which is how I’ve been able to write this blog post.
Having an article about SAS published in VIEWS News is the only qualification required to become a VIEWS Consultant, which is globally recognized, but is unpaid, like the Newsletter Editor!
VIEWS News is now being published quarterly in February, May, August and November, and I am constantly looking for new SAS-related content and new contributors. Contributions should be short punchy articles about SAS-related topics, reviews of SAS-related conferences you have attended, or even advertising articles for future conferences. The choice is completely up to you, and my task, as Newsletter Editor, is to put together an issue with a range of articles that will be of interest to our global membership. Therefore, if you have an idea for something you’d like to contribute to the next, or future, issue of VIEWS News, then please contact me at views-uk@hollandnumerics.org.uk. I just need any articles for each issue before the 1st day of the publication month, so I can include it in the newsletter, and give you the opportunity to check that I’ve not changed anything important before the final published version is posted on the site.
If you are thinking about contributing to VIEWS News, then I would recommend you register on this blog site and request access to VIEWS News, as you will need to log in to the blog site to get to the VIEWS UK forum, where VIEWS News lives, so you will have access to the past issues. As I write this post the blog members that have requested access to VIEWS News (total 116) are located in:
UK = 47
North America = 27
Indian Sub-continent = 23
Europe = 13
Rest of the World = 6
Many of the blog members that have requested access to VIEWS News are already VIEWS Consultants, and more contributions are welcomed from them. However, I also encourage you to become a new VIEWS Consultant.
Remember the deadline for articles in the August issue (VIEWS 57) is the 1st August!!
PharmaSUG US 2019 was held at the Philadelphia Marriott Downtown from 15-19 June 2019.
My wife and I flew from London to Boston, where we spent 2 nights visiting the historical sites in and around the city, as well as tasting some excellent local beers.
We then flew to Buffalo and crossed the border into Canada to visit Niagara Falls for 2 nights, walking behind the Horseshoe Falls and braving the mist. This spot had been high on my wife’s “bucket list” for many years. Admittedly the Hornblower catamarans used from the Canadian side do have transparent screens, so we didn’t get as wet as some of the other passengers! In contrast, the Maid of the Mists boats from the American side have no protection at all, but, as single-hull boats, can’t approach as close to the falls either.
We then flew from Buffalo to Philadelphia for the start of PharmaSUG, where I was a First Timer. I proudly wore my First Timer ribbon legitimately, as I’d never been to PharmaSUG before, along with my Presenter and Code Doctor ribbons. However, it was also a bit misleading, as I’ve presented previously at more than 30 international conferences in Europe and the USA, so several conference friends told me off for cheating.
My presentation wasn’t about ODS Graphics this time, but about SAS programming techniques to reduce data surprises. The room was about half full early on Tuesday morning, and, judging by the number of questions afterwards, well received (and I didn’t see anyone leave in the middle!). My room was run with friendship and precision by Frank Canale and Maggie Ying, who both made me very welcome, so I must give them a big thank you.
I had sat on the Code Doctors table in the “Code Clinic” at SAS Global Forum, but my 2 official sessions in Philadelphia, and several unofficial sessions too, were actually more enjoyable. Each session started very quietly, so I got to chat with my fellow Doctors, many of whom I’d met many times before. The last half hour of each session was filled with varied questions about concatenating strings in R, working around annoying “features” in old Microsoft applets, and answering questions about CDISC SDTM and ADaM specifications. Note the lack of “real” SAS questions, but still very entertaining, and I hope the answers proved useful!
PharmaSUG US 2019 had a record attendance of 910 this year, but I’d previously attended SAS Global Forum with 6,500 attendees, so it felt much smaller and more personable. Being relatively small also made it easier to meet up with people there. The conference lunches were excellent too, so a big thank you to MaryAnne DePesquo, although I was initially worried she might be cross with me for missing SAS Global Forum 2019 in Dallas, where she was Conference Chair, but she did forgive me!
I knew I would meet several conference friends I’d met before at SAS Global Forum and PhUSE, but I never expected so many friends would be there. In fact there were, apparently, rumours beforehand that I was coming to PharmaSUG, and some there didn’t believe them! Anyway, everyone was very welcoming, and I made lots of new conference friends at PharmaSUG too.
I have run free prize draws for copies of my latest book at most of the conferences I had attended since it was published in 2015, using the free copies Apress, the publisher, had sent me. My penultimate book prize draw at PharmaSUG was won by Qinxiao (Catherine) Shi, a Statistics student from the University of Connecticut (see photo). I wish I’d been able to take a photo of her reaction when she found out she had won. Let’s just say she was very pleased to win!
After 9 days in North America we had to travel home to the UK again, but not without one last adventure by rail, as I had booked a train from Philadelphia to Penn Station in New York. From there we had to catch 2 more trains, buying tickets before each leg, to get to JFK, our departure airport. While the potential issues were many, including an unexpected power outage at the station in Philadelphia that morning, I can report nothing untoward happened en route to JFK, and we even arrived there earlier than expected.
Now we have been back in the UK a few days, I’ve had time to reflect on our PharmaSUG journey, and all I can think of are 3 words: Welcoming, Enlightening and Worthwhile! Thank you everyone we’ve met in the USA and Canada. We’ll be back!
PS. For those interested in my beer tastings, I tasted 20 new beers during this journey: 4 in Boston, 4 in Niagara, 11 in Philadelphia and finally 1 in New York.
You must be logged in to post a comment.