>Hi Sergey, good answer but it did not work. I tried that earlier today and it did sound very promising. I am working with SAS tech support so I hope to get this resolved early next week. There is very little information available on the SAS Integrated Object Model (IOM) but I think that the SAS and VFP combo is a very powerful combination.
>
>I am using SAS for Data Mining (running against tables with 700 million rows of data) on a UNIX server and sending summarized results back to VFP via ADO recordsets and then feeding that directly into an Excel PivotTable. I did a sample test and pulled 600K rows from a SAS dataset on UNIX via VFP then pushed the data into Excel in less than a minute. I see a lot of potential in harnessing the power of SAS for analytics and HTML, Excel and other Office products for the output.
>
>The piece I am trying to get working now would allow me to use VFP as a development front end (if I want) to push blocks of SAS code directly to the UNIX processor. I do think it will eventually get resolved - at least I hope so. Only problem is that there are not many persons that use SAS and VFP in this way...
Hi Tom,
You can also take a look at
Constructor for SafeArrays FAQ #7979 and
SafeArray File #
19225
--sb--