What formats can I export SAS logic as ?

[UdayGuntupalli]

All, 

 I am new to SAS and still exploring the basics. However, I have a conceptual question that people might have previously run into. Would appreciate if the community members guide me in the right direction. 

 If I develop an algorithm in SAS - can this logic be exported out of SAS for use by other applications  ?

 For e.g. I can generate .exe or SQL Stored procedures for my logic in many languages. I would like to see an exhaustive list of all the formats if any that SAS logic can be exported. 

Appreciate all the help

Best 
Uday 

[Reeza]

That depends. If it's a statistical type model there is some functionality for that, but SAS is designed for Statistical Analysis (Statistical Analysis Software), it's not designed to create standalone applications and I wouldn't recommend using it for that. In general, you'll need whoever wants to use your algorithm to also have SAS installed.

---

@UdayGuntupalli wrote:

All, 

 I am new to SAS and still exploring the basics. However, I have a conceptual question that people might have previously run into. Would appreciate if the community members guide me in the right direction. 

 If I develop an algorithm in SAS - can this logic be exported out of SAS for use by other applications  ?

 For e.g. I can generate .exe or SQL Stored procedures for my logic in many languages. I would like to see an exhaustive list of all the formats if any that SAS logic can be exported. 

Appreciate all the help

Best 
Uday 

---

[ballardw]

Generally not if I understand your question.

If mean by exe a "stand alone program developed with SAS that does not require a SAS installation to run" pretty much a firm no as I understand it.

SAS Proc Sql code is mostly ANSI standard though, as most flavors of SQL do, has some functions available not in standard.

However the code would have to have the SAS Procedure wrapper Proc sql; quit; removed and have to be moved into another environment that lets you paste scripts where that environment has like named libraries and data sets.

The LOGIC can be exported but done by a human. I haven't seen any expert system yet that was reliable enough to say that the process was easy or automatic, similar to "comment compilers" from years back.  I have developed processes in SAS for testing as the code was more flexible than another languages code, FORTRAN in my case. But I still had to know the elements of both languages.

[UdayGuntupalli]

@ballardw, 
         So, is it not possible to leverage solutions developed  through SAS to be implemented where my data sits i.e. for e.g. if Salesforce is my data source , then would I need to pass all the data to SAS and not perform the analysis developed in SAS at my data source ? 

Ideally, I would hope if the logic is exportable, then it can be deployed at the data source to avoid moving large amounts of data or am I looking at this the wrong way ? 

[ballardw]

---

@UdayGuntupalli wrote:

@ballardw, 
         So, is it not possible to leverage solutions developed  through SAS to be implemented where my data sits i.e. for e.g. if Salesforce is my data source , then would I need to pass all the data to SAS and not perform the analysis developed in SAS at my data source ? 

Ideally, I would hope if the logic is exportable, then it can be deployed at the data source to avoid moving large amounts of data or am I looking at this the wrong way ? 

---

A generic question gets a generic response.

If you have data in  specific data base then you can access that data from SAS which may move things around.

You may have to be very specific in describing what you mean by "logic". There are large number of tools and modules in SAS that do different things. Browse around this page: https://support.sas.com/software/ for awhile to get a feel of how SAS works with different types of solutions. You are very likely to find some answers there. Or contact the SAS sales office about what you need to get a better targeted response.

[AlanC]

SAS can use pass-through logic to execute the logic on a remote platform. For example, if a shop has Teradata, SAS can pass TD SQL to TD and have TD perform the logic locally then send the results back to SAS.

If the question is "can I code something in SAS and then convert the logic, automatically, to Python, Java, C#, etc. the answer is no. You can use those languages to call SAS and perform individualized functions but you cannot convert from one language to the other except manually.

[Astounding · Accepted solution]

Going by distant, hazy recollection ...

I believe that Enterprise Miner can output scoring code in PMML.  For what it's worth, of course.