topic Re: .NET PROC SQL Tabular Results in New SAS User

.NET PROC SQL Tabular Results

chrisguhc — Wed, 05 Jun 2019 17:55:16 GMT

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!

Re: .NET PROC SQL Tabular Results

Reeza — Wed, 05 Jun 2019 17:58:53 GMT

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

Re: .NET PROC SQL Tabular Results

chrisguhc — Wed, 05 Jun 2019 18:44:23 GMT

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.