It looks like you may not have installed the OleDb provider properly. Below is C# code that will check it for you. I would download it from SAS and try again. Here is some C# code I use that uses the OleDb provider. You can also see C#/SAS code on my github (savian-net (ALAN CHURCHILL) · GitHub). There may be more examples there for SAS OleDb:   internal static List<string> GetOleDbProviders() { var oleEnum = new OleDbEnumerator(); var elems = oleEnum.GetElements(); var providers = new List<string>(); if (elems != null && elems.Rows != null) { foreach (DataRow row in elems.Rows) { if (!row.IsNull("SOURCES_NAME") && row["SOURCES_NAME"] is string) { providers.Add(row["SOURCES_NAME"].ToString()); } } } return providers; } public SasDataSetUtilities() { _isSasOleDbInstalled = IsSasOleDbInstalled(); } public bool IsSasOleDbInstalled() { var oleDbProviders = DbUtilities.GetOleDbProviders(); if (oleDbProviders.Any(p => p.ToUpper().StartsWith("SAS LOCAL"))) return true; return false; }   public DataTable GetSasDataSetMetadataAsTableUsingOleDb(string sasLibrary, string dataset) { if (_isSasOleDbInstalled is false) { Log.Error("SAS OleDb driver is not installed. Please install the driver from the SAS Support website"); return null; } OleDbConnection sas = null; try { sas = new OleDbConnection(@"Provider=sas.LocalProvider; Data Source=" + sasLibrary); sas.Open(); OleDbCommand sasCommand = sas.CreateCommand(); sasCommand.CommandType = CommandType.TableDirect; sasCommand.CommandText = dataset; DataTable dt = sas.GetSchema("Columns"); DataView dv = dt.DefaultView; dv.RowFilter = "TABLE_NAME = '" + dataset.ToUpper() + "'"; sas.Close(); return dv.ToTable(); } catch (Exception ex) { Log.Error("Failed to get SAS metadata", ex); return null; } }     ... View more

This is simply a codegen problem. Lots of codegen solutions to choose from. I use C# to do it a lot but spent my final years at SAS doing codegen using SAS. Here is an example. Note: I have a utility on my website (postsas.com) that helps with codegen:    data _null_; *data TEST ; file CGSELECT ; set &reflib..&refTable. end=eof; if _n_ = 1 then do ; put @3 '%include preProcessForCodeGen.sas;' / @3 'SELECT; ' ; end; put @6 'WHEN ('; %include CGCONDTN ; put @13 ') ' @13 'DO;' / @13 ' CONDITION = ' _N_ ';' %do i = 1 %to &numValues.; %if &&assignVar&i.. NE %then %do ; %PUT "ASSIGN=&&assignVar&i.."; / @13 " &&outVar&i.. = &&assignVar&i.. ;" %end; %else %if &&outVartype&i.. = 1 %then %do; %PUT 'IN 1'; / @13 " &&outVar&i.. = &&outVartype&i.. ;" %end; %else %if &&outVartype&i.. = 2 %then %do; %PUT 'IN 2'; / @13 " &&outVar&i.. = '&&outVartype&i..' ;" %end; %end; / @13 'END;' ; if eof then do ; put @6 'OTHERWISE' /@6 ' DO; ' /@6 ' CONDITION=-99999; ' ; %* I think I prefer not defining in this case because we may want this process to create char data?; %include CGOTHER; put @6 ' END; ' /@3 'END;' /@3 '%include postProcessForCodeGen.sas;' ; end; run; ... View more