Date: Thu, 8 Jun 2006 10:06:10 -0600
Reply-To: Alan Churchill <SASL001@SAVIAN.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Alan Churchill <SASL001@SAVIAN.NET>
Subject: Re: call libraries
Content-Type: text/plain; charset="iso-8859-1"
Why not have a C# program call SAS? That way you can pass parms to your
other C# program easily and manage SAS?
C# exe ---> Call C# code to run db query
<-- Serialize results or store in memory if same C# code
Consider using an intermediate store here such as Access, XML, SQL Server
C# exe ---> write to intermediate store
SAS <--- read store
You cannot write a SAS dataset: the layout is proprietary. Stat\Transfer
folks are the only guys I know that can.
Finally, you can also pipe data but I think this is kludgy.
I'm curious what others think.
BTW, do you have Int Tech?
Savian "Bridging SAS and Microsoft Technologies"
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Thursday, June 08, 2006 8:30 AM
Subject: call libraries
starting from an old discussion around SASCBTL and C++ module, I would like
to know now if, with the SASv9 and IT module, I can use something new to
call a .EXE + parameters from SAS :
(For an old similar problem with SASv8, I used SASCBTL statement via a macro
called by users which use a C++ DLL made for the access.
the limits was that I didn't manage the double arrays (dll creates a flat
file) and it wasn't a EXE to call but a DLL);
suppose we have now a getsomething.EXE to reach a database that, for
security reason, the direct access is prohibited.
the .exe calls a method to extract data and returns a double arrays
The double arrays have to be used to create a SAS table.
the .exe is a C# or C++ program.