https://communities.sas.com/t5/SAS-Enterprise-Guide/Updating-Creating-a-SAS-Dataset-with-NET/m-p/39268#M4722 hi,<BR /> <BR /> I'm developing a .NET program which creates an ADO.NET DataTable from an existing SAS Library via the SAS OleDB dataprovider and now i want to write the changes in the DataTable back to SAS.<BR /> <BR /> After reading the documentation for SAS IT, SAS IOM, SAS OleDB Provider i come to the conclusion that there is no simple way to achieve this. The most helpful documentation i found was this:<BR /> <BR /> <A href="http://support.sas.com/documentation/tools/oledb/rr_createdelete.htm" target="_blank">http://support.sas.com/documentation/tools/oledb/rr_createdelete.htm</A><BR /> <BR /> There are three methods described:<BR /> 1) using SQL Statements will be difficult and i guess that the performance will be terrible if i submit a CREATE TABLE followed by a million INSERT INTO SQL Statements.<BR /> 2) using the ITableDefinition interface: is this even possible in .NET? Can i add rows to the table?<BR /> 3) using ADOX: seems to be the only reasonable method to create and fill a SAS dataset. Has anybody tried that method yet?<BR /> <BR /> Am i missing something here? Is there really no simple solution provided by SAS to update or create a new SAS dataset when you are using SAS/IT with the SAS data providers in the .NET Framework?<BR /> <BR /> I hope that Chris or somebody else can help me! Wed, 24 Nov 2010 17:46:23 GMT AndreasMenrath 2010-11-24T17:46:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Updating-Creating-a-SAS-Dataset-with-NET/m-p/39268#M4722 hi,<BR /> <BR /> I'm developing a .NET program which creates an ADO.NET DataTable from an existing SAS Library via the SAS OleDB dataprovider and now i want to write the changes in the DataTable back to SAS.<BR /> <BR /> After reading the documentation for SAS IT, SAS IOM, SAS OleDB Provider i come to the conclusion that there is no simple way to achieve this. The most helpful documentation i found was this:<BR /> <BR /> <A href="http://support.sas.com/documentation/tools/oledb/rr_createdelete.htm" target="_blank">http://support.sas.com/documentation/tools/oledb/rr_createdelete.htm</A><BR /> <BR /> There are three methods described:<BR /> 1) using SQL Statements will be difficult and i guess that the performance will be terrible if i submit a CREATE TABLE followed by a million INSERT INTO SQL Statements.<BR /> 2) using the ITableDefinition interface: is this even possible in .NET? Can i add rows to the table?<BR /> 3) using ADOX: seems to be the only reasonable method to create and fill a SAS dataset. Has anybody tried that method yet?<BR /> <BR /> Am i missing something here? Is there really no simple solution provided by SAS to update or create a new SAS dataset when you are using SAS/IT with the SAS data providers in the .NET Framework?<BR /> <BR /> I hope that Chris or somebody else can help me! Wed, 24 Nov 2010 17:46:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Updating-Creating-a-SAS-Dataset-with-NET/m-p/39268#M4722 AndreasMenrath 2010-11-24T17:46:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Updating-Creating-a-SAS-Dataset-with-NET/m-p/39269#M4723 Andreas,<BR /> <BR /> Here is an example EG custom task that does this:<BR /> <BR /> <A href="http://support.sas.com/documentation/onlinedoc/guide/customtasks/samples/FSEdit42.zip" target="_blank">http://support.sas.com/documentation/onlinedoc/guide/customtasks/samples/FSEdit42.zip</A><BR /> <BR /> I realize your application is not running within EG, but you could use a similar approach. That is, use the SAS IOM OLE DB provider to read the data, and use the SAS Workspace LanguageService to update the data table using PROC SQL UPDATE.<BR /> <BR /> Chris Tue, 30 Nov 2010 20:09:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Updating-Creating-a-SAS-Dataset-with-NET/m-p/39269#M4723 ChrisHemedinger 2010-11-30T20:09:57Z