https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48390#M5337 If you are limited to EG, I would say no.<BR /> We have also tried to use it to update data, and it doesn't work too well on all scenarios.<BR /> Is there are specific problem which makes you looking for an alternative?<BR /> <BR /> /Linus Sat, 23 Apr 2011 19:39:28 GMT LinusH 2011-04-23T19:39:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48387#M5334 Hi there, i wonder if there is any practical way to update data in MSSQL through EG with direct modification on data value in a dataview.<BR /> <BR /> I currently assigned a library referencing to MSSQL database and direct open the data in the library with data protect off to have direct modification on MSSQL data.<BR /> <BR /> I wonder if there is any other method, please advice thanks Tue, 12 Apr 2011 07:36:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48387#M5334 SASDump 2011-04-12T07:36:40Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48388#M5335 You should be able to use the normal SAS update procedures like proc sql or data step modify. Tue, 12 Apr 2011 11:57:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48388#M5335 DBailey 2011-04-12T11:57:26Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48389#M5336 Yes, I know I could use SAS procedure SQL or data step to update. I am just asking for alternative with direct modification on data just by dataview. And i am asking if I am using the practical way to perform this? I just wndering if there is other way to do such purpose. Please advice thanks! Tue, 12 Apr 2011 14:35:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48389#M5336 SASDump 2011-04-12T14:35:56Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48390#M5337 If you are limited to EG, I would say no.<BR /> We have also tried to use it to update data, and it doesn't work too well on all scenarios.<BR /> Is there are specific problem which makes you looking for an alternative?<BR /> <BR /> /Linus Sat, 23 Apr 2011 19:39:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48390#M5337 LinusH 2011-04-23T19:39:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48391#M5338 well, actually updating via sas dataset can be the solution of my case for direct updating the data in MSSQL table. I am just trying figure out if there is any alternative only as i am a nobody in SAS environment and just want to have some feedback from you guys expert or experienced programmer in SAS. Thanks for your reply! Sun, 24 Apr 2011 14:49:17 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48391#M5338 SASDump 2011-04-24T14:49:17Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48392#M5339 Updating via data viewer can work ok, but it's not ideal.<BR /> Things to consider:<BR /> -Avoid meta libanme<BR /> -Defaults constraints: it won't work, especially together with NOT NULL constraint.<BR /> <BR /> /Linus Tue, 26 Apr 2011 10:24:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Modify-data-in-MSSQL-data-table/m-p/48392#M5339 LinusH 2011-04-26T10:24:31Z