topic Re: Conversion of SAS Code to Python in SAS Programming

Conversion of SAS Code to Python

Mayank_61 — Thu, 21 Apr 2022 18:40:19 GMT

Hi,

Is there any way in which we can automate the conversion of a SAS code to Python.

The automation process not necessarily need to be in SAS, it can also be in python with some predefined python library.

Any link to the solution or some predefined workflow will be really helpful.

Thank you

Regards,

Mayank

Re: Conversion of SAS Code to Python

r_behata — Thu, 21 Apr 2022 18:56:32 GMT

Check SASPy

Re: Conversion of SAS Code to Python

Quentin — Thu, 21 Apr 2022 19:17:53 GMT

I doubt there's a good way. See this thread with same question:

https://communities.sas.com/t5/SAS-Data-Science/SAS-to-Python/td-p/729384

If you google a bit you'll fine companies selling translations / translators, but I'm not sure I would trust them. One has a 90% guarantee. Hard to imagine something worse than correctly translating 90% of a program into a new language.

If you're going to switch to python, probably better to invest in hiring / learning python, and have python programmers sit down with requirements and build in python. SAS code is pretty easy to read, so if you have requirements, SAS code, and a few people who know SAS, would think it could be done. Of course it's a big migration (potentially), you might want to rearchitect your full analytic environment at one time, not just switch the language.

Re: Conversion of SAS Code to Python

Sajid01 — Thu, 21 Apr 2022 19:48:27 GMT

Hello @Mayank_61

I agree with what @Quentin has suggested.

SAS and Python are two different application softwares which perform identical set of tasks for example data analysis, statistics etc in their own distinct way. But there is no one to one corrospondence between a function in SAS with that in Python. Any translator, if available, may not be effiecient.
It is better to focus on the task a SAS program does and write the same job in Python. This will require more resources in development but save time in debugging a faulty translation.

Re: Conversion of SAS Code to Python

Kurt_Bremser — Thu, 21 Apr 2022 20:03:36 GMT

What I said in the thread @Quentin linked to still holds true. Start with the original requirements, and have the program(s) rebuilt from scratch by (a) Python specialist(s). Don't even think about a "conversion" that will have you end up with a piece of unmaintainable junk.

If this proves to make no sense economically, stay with SAS.

Keep in mind: this is not like translating PASCAL to C. The paradigms are completely different.

Re: Conversion of SAS Code to Python

SASKiwi — Thu, 21 Apr 2022 20:09:30 GMT

Just to add to the specific SAS to Python code conversion discussion, I've never seen a reliable, automatic way to convert from ANY computer language to ANY other one where the architecture and syntax is radically different. It's a different story where you have different flavours of the same computer language like SQL, BASIC, C and so on but that's not what we are talking about here. And let's not get started on software that's incompatible between versions...

Re: Conversion of SAS Code to Python

maryana — Wed, 11 May 2022 01:25:54 GMT

I am just doing a market research on Automatic tool/services for translating from SAS code to python (don't want to use them).

So far, I found wise with data, SAS2PY and Semantic Designs.

Would you please name the translator tool/services if you know any more?

Thanks

Re: Conversion of SAS Code to Python

kbohle — Thu, 04 May 2023 07:20:43 GMT

Hi,

please look at https://www.wisewithdata.com/sas-to-pyspark-migration-solution-2/

This company I found in addition to the two you already listed.

I found in addition a Web based tool doing translations between differnt programming languages. This tool offers a lot of programming languages including SAS and Python.

https://codeconverter.com/?gclid=Cj0KCQjw6cKiBhD5ARIsAKXUdyb7-UR64w8VG8vk7aDhWYX8PXhR1sAlOgsAXl-mAxTrNdqnaNpSU9UaAm76EALw_wcB

Re: Conversion of SAS Code to Python

Arjun-V — Sat, 11 Nov 2023 12:58:31 GMT

Hi Mayank,

We have exactly done the same. We have parsed SAS code and converted into Python code. We were able to achieve 95% during the automation process and 5% manual intervention is needed to do some configuration etc. If you are interested, you can reach out to me and discuss in detail.

My name is Varatharajkumar (Als.) Arjun, from Chennai, India. I am the Founder and COO of Rushmore Technologies Private Limited.

My Mail id : arjun@rushmoretech.in

Mobile No: +91 9840171191.

You can feel free to reach me anytime at your convenience. Thank you.

Re: Conversion of SAS Code to Python

Arjun-V — Sat, 11 Nov 2023 17:12:48 GMT

We tested and fond that our tool perform far better than wisewithdata, leap logic, sas2py and symantic designs

Re: Conversion of SAS Code to Python

luisilabaca — Tue, 07 Jan 2025 00:04:40 GMT

Hello there world

My name is Luis Ilabaca - I am a consultant and have worked on various projects working on SAS, Python, AWS... etc

If you are working on a SAS to Python conversion ( of many many codes ) please let me give you a 20 minute presentation.

in it i will demo some tools and give you a presentation - and at the bare minumum it would just be "wasted 20 minutes" but hope you can walk away with many good ideas

the nature of programming is open source so i would like to show you concrete solutions on how to approach this problem.

you can reach me at LuisIlabaca3@gmail.com ( also you can see my linked in but i admit i don't always log in there - and the bots in linked in now a days flood your inbox )

Re: Conversion of SAS Code to Python

irajatsingh — Fri, 10 Jan 2025 11:55:51 GMT

I have also found an ai based code converter website that works seamlessy for free

Re: Conversion of SAS Code to Python

Taha_0703 — Wed, 03 Dec 2025 07:30:51 GMT

Yeah, even I have got an ask to convert SAS code to python but since these asks are frequent, we have been asked to build an accelerator that would do the SAS to python conversion..