What formats can I export SAS logic as ?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

What formats can I export SAS logic as ?

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 


Accepted Solutions
Solution
‎01-27-2018 10:17 PM
Super User
Posts: 6,622

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

Going by distant, hazy recollection ...

 

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

View solution in original post


All Replies
Super User
Posts: 23,224

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

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 


 

Super User
Posts: 13,283

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

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.

 

 

Occasional Contributor
Posts: 18

Re: What formats can I export SAS logic as ?

@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 ? 

Super User
Posts: 13,283

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

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.

Regular Contributor
Posts: 150

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

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.

Solution
‎01-27-2018 10:17 PM
Super User
Posts: 6,622

Re: What formats can I export SAS logic as ?

Posted in reply to UdayGuntupalli

Going by distant, hazy recollection ...

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 179 views
  • 2 likes
  • 5 in conversation