.NET PROC SQL Tabular Results

[chrisguhc]

I have been working with SAS.Workspace in C# .NET

I have been able to generate passthrough SQL results using:

provider=sas.iomprovider.1; SAS Workspace ID=" + objSAS.UniqueIdentifier

I have been able to generate Logs via:

SAS.LanguageService.Submit + FlushLogLines

I can also run, execute and generate text results for PROC SQL using:

SAS.LanguageService.Submit +FlushListLines

Is there anyway to get tabular or even delimited based results from running PROC SQL  via .NET SAS ?

Thanks in advance!

[Reeza]

Is your PROC SQL doing SELECT only or are you creating tables?

[chrisguhc]

Here is an example of what I am trying to run:

proc sql OUTOBS=5;
select * FROM alias.table;

I realize I could probably tweak this to run as a Passthrough SQL but I'd really like to have PROC SQL return a datatable or something usable as opposed to just un-parsable text results I currently get.