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!
If you are limited to EG, I would say no.
We have also tried to use it to update data, and it doesn't work too well on all scenarios.
Is there are specific problem which makes you looking for an alternative?
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!