sas-to-databricks-migration

Convert SAS PROC SQL, DATA steps, PROC MEANS, and PROC FREQ into PySpark or Spark SQL for Databricks.

Updated Jan 22, 2026
One-click install
npx skills add https://github.com/bigdatavik/databricks-skills-legacy-migration --skill sas-to-databricks-migration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sas-to-databricks-migration
Source: https://github.com/bigdatavik/databricks-skills-legacy-migration/tree/main/skills/sas-migration
Command: npx skills add https://github.com/bigdatavik/databricks-skills-legacy-migration --skill sas-to-databricks-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the conversion of legacy SAS analytical code into modern, production-ready PySpark or Spark SQL, enabling efficient migration to the Databricks Lakehouse platform.

Core Features & Use Cases

  • Code Conversion: Translates SAS PROC SQL, DATA steps, PROC MEANS, and PROC FREQ into equivalent PySpark or Spark SQL code.
  • Healthcare Analytics Focus: Optimized for migrating healthcare payer analytics, including HEDIS measures, Risk Adjustment (RAF/HCC), claims processing, and prior authorization workflows.
  • Use Case: Convert a complex SAS program that calculates HEDIS measures into PySpark code that runs efficiently on Databricks, ensuring data quality and performance.

Quick Start

Use the sas-to-databricks-migration skill to convert the provided SAS PROC SQL code into PySpark.

Frequently Asked Questions about sas-to-databricks-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert SAS PROC SQL and DATA steps to PySpark for Databricks?

To convert SAS PROC SQL and DATA steps to PySpark for Databricks, use automated migration logic that translates legacy code into equivalent Spark SQL or PySpark scripts. This ensures your analytics workflows run efficiently on the Databricks Lakehouse platform.

Can I migrate healthcare HEDIS measures and RAF risk adjustment code from SAS to Spark SQL?

Yes, you can migrate healthcare HEDIS measures and RAF risk adjustment code from SAS to Spark SQL. The conversion process specializes in healthcare payer analytics, translating claims processing and prior authorization workflows into production-ready PySpark.

What is the best way to translate SAS PROC MEANS and PROC FREQ into Spark SQL?

The best way to translate SAS PROC MEANS and PROC FREQ into Spark SQL is through a specialized conversion process that maps statistical procedures to equivalent Spark dataframe aggregations. This preserves analytical integrity while optimizing for Databricks naming conventions.

Does SAS to Databricks migration handle healthcare claims analytics workflows?

Yes, SAS to Databricks migration handles healthcare claims analytics workflows. The conversion is optimized for payer analytics, ensuring that complex claims data processing and prior authorization logic are accurately translated into PySpark.

Do I need to manually optimize PySpark code after migrating from SAS?

You do not need to manually optimize PySpark code after migrating from SAS, as the conversion adheres to Databricks environment and naming conventions. The resulting code is designed to be production-ready and efficient for the Lakehouse platform.

Why use PySpark instead of Spark SQL when converting SAS code for Databricks?

Using PySpark instead of Spark SQL when converting SAS code for Databricks allows for more complex procedural logic from SAS DATA steps to be translated into Python. Both PySpark and Spark SQL are supported as output formats depending on the structure of the legacy code.