Period
to 24 June 2018

The following table provides summary statistics for permanent job vacancies with a requirement for PROC SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited PROC SQL over the 6 months to 24 June 2018 with a comparison to the same period in the previous 2 years.

SAS SQL Procedure (PROC SQL)
UK
6 months to
24 Jun 2018
Same period 2017 Same period 2016
Rank 1176 1151 1287
Rank change year-on-year -25 +136 +18
Permanent jobs citing PROC SQL 10 50 1
As % of all permanent IT jobs advertised in the UK 0.006% 0.029% 0.000%
As % of the Programming Languages category 0.010% 0.052% 0.001%
Number of salaries quoted 0 30 0
UK median annual salary - £45,250 -
UK excluding London median annual salary - £45,250 -

PROC SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for coding skills.

All Programming Languages
UK
Permanent vacancies with a requirement for coding skills 97,501 95,648 105,066
As % of all permanent IT jobs advertised in the UK 56.09% 55.26% 52.16%
Number of salaries quoted 81,144 80,730 90,761
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £80,000 £76,250 £75,000
UK excluding London median annual salary £45,000 £42,133 £40,000
% change year-on-year +6.81% +5.33% -

PROC SQL
Job Vacancy Trend

Job postings citing PROC SQL as a percentage of all IT jobs advertised.

Job vacancy trend for PROC SQL in the UK

PROC SQL
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing PROC SQL.

Salary trend for PROC SQL in the UK

PROC SQL
Top 4 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing PROC SQL within the UK over the 6 months to 24 June 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
North of England +7 10 - -
North West -13 10 - -
UK excluding London -37 10 - -
England -38 10 - -

For the 6 months to 24 June 2018, IT jobs citing PROC SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for PROC SQL.

1 10 (100.00%) SQL
1 10 (100.00%) SAS
1 10 (100.00%) ProC
1 10 (100.00%) Finance
1 10 (100.00%) Stakeholder Management
1 10 (100.00%) Banking
1 10 (100.00%) SAS Macro
1 10 (100.00%) Base SAS
1 10 (100.00%) SAS Enterprise Guide
1 10 (100.00%) Analytics
1 10 (100.00%) Infrastructure Management
1 10 (100.00%) SAS Data Integration Studio
1 10 (100.00%) Visual Analytics
1 10 (100.00%) Mentoring
1 10 (100.00%) Analytical Skills
1 10 (100.00%) People Management
1 10 (100.00%) SAS Visual Analytics

PROC SQL
Co-occurring IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 10 (100.00%) SAS
Database & Business Intelligence
1 10 (100.00%) Base SAS
1 10 (100.00%) SAS Data Integration Studio
1 10 (100.00%) SAS Enterprise Guide
1 10 (100.00%) SAS Visual Analytics
Development Applications
1 10 (100.00%) ProC
General
1 10 (100.00%) Banking
1 10 (100.00%) Finance
Job Titles
1 5 (50.00%) Consultant
1 5 (50.00%) SAS Consultant
1 5 (50.00%) Senior Consultant
1 5 (50.00%) Senior SAS Consultant
Miscellaneous
1 10 (100.00%) Analytical Skills
Processes & Methodologies
1 10 (100.00%) Analytics
1 10 (100.00%) Infrastructure Management
1 10 (100.00%) Mentoring
1 10 (100.00%) People Management
1 10 (100.00%) Stakeholder Management
1 10 (100.00%) Visual Analytics
Programming Languages
1 10 (100.00%) SAS Macro
1 10 (100.00%) SQL