SAS APPLICATION PROGRAMMER

Minimum Qualifications Required

• Bachelor s degree in Computer Science, Statistics, Mathematics, Data Science, or a closely related field; or equivalent experience.
• 6+ years of professional SAS programming experience (Base SAS and Macro), developing productiongrade code.
• Strong PROC SQL skills and proficiency with Data Step programming, arrays, and macros.
• Hands-on experience with ODS to generate RTF/PDF/HTML/Excel deliverables.
• Proficiency with PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC TRANSPOSE, PROC COMPARE, and use of SOUNDEX and custom formats.
• Experience implementing data quality controls, peer review/validation, and documentation standards.
• Experience working with enterprise data warehouses (e.g., Oracle EDW) and large relational datasets.
• Base SAS Programmer and/or Advanced SAS Programmer certification, or equivalent demonstrated expertise

Project Overview

The SAS Application Programmer has advanced skills in SAS programming and development. Programs and macros are developed to manipulate, analyze, and disseminate data.

Duties/Responsibilities

• Develop PROC SQL data queries to query and subset detail and summary data from the MSDE data warehouse, summarize detail data, combine tables using joins and set operators, and use macro
• variables in SQL.
• Develop and perform programming to manipulate data by merging, appending, and sorting datasets; manipulate data with functions; create custom formats; concatenate and merge tables;
• process repetitive code (DO loop and SAS array); restructure tables (PROC TRANSPOSE); and perform pattern matching (SOUNDEX).
• Use Macro functions and write SAS Macro programs to facilitate and automate data management operations.
• Use Output Delivery System (ODS) to produce RTF, PDF, HTML, and EXCEL deliverables.
• Use SAS for descriptive and inferential statistical analysis (PROC MEANS, PROC FREQ, PROCUNIVARIATE).
• Use PROC COMPARE to create verification PDF or RTF reports of databases and metadata stored in the Education Data Warehouse (EDW).
• Develop quality-assurance syntax to perform data checks to ensure correctness and integrity of education data.
• Collaborate with the data warehouse architect to ensure integrity of stored data in the MSDE data warehouse and resolve data issues.

• Perform quality review and validation of SAS programs generated by data analysts or other SAS programmers.
• Establish and maintain program folders of fully documented and validated SAS programs/macros/procedures.
• Modify/update SAS code to incorporate changes in data collection and reporting processes.
• Acquire knowledge about manuals related to MSDE data collections, gather business requirements for federal/state reporting, and provide recommendations.

Resolve SAS performance problems and monitor computer resources and efficiency