05-11-2016 05:04 PM
Please, I would like to know, if we can find an open source "inerface" to use with "SAS Entreprise Guid".
application sas EG (in the back office) + user inerface (for reporting) ?
What's about sas and acces inerface ?
05-11-2016 06:12 PM
Enterprise Guide is an interface as is Base SAS. Data analysis can also be done in batch mode or command line mode but I'm not aware of any "canned" interface specific to SAS. What is missing or what problems are you encountering that makes want a different interface?
Access to a number of data sources is in the SAS/Access module which has available interfaces to many database systems. Also ODBC is available from SAS.
05-11-2016 06:26 PM
I do not want to use a sas base ( in back office)
acces perhaps as interface.
I want to create a reeport, if we click on " button in a nice inerface ", I get the report, but behind this report, some treatement
05-12-2016 08:37 AM
I agree with @LinusH - you probably want to use SAS stored processes, which you can invoke via web service or VBA. SAS offers the SAS Add-In for Microsoft Office, which provides you with access to SAS data and computations in Microsoft Excel, Word, PowerPoint and Outlook -- but not Microsoft Access. For that, you'll have to use the open APIs to call stored processes or access data using ODBC or OLE DB.
05-14-2016 08:36 AM - edited 05-14-2016 08:37 AM
Thank you your answer.
Please, I have two questions :
1- To do that , Can we use a SAS stored processes with VBA. if we do not have a SAS Add-In for Microsoft Office ?
2- Please, can you give some exemples "the open APIs to call stored processes" ?
05-16-2016 06:54 PM
05-18-2016 01:03 AM