@Kodit - GREAT question! A Stored Process Web Application is the perfect choice for letting users make changes to data, for reasons such as the following: - Updates are made using a system account (eg sassrv) so the end user doesn't need to have write access to sensitive data - You can apply validation at point of data entry - It's much easier for users / developers alike The very first piece of advice I have for you is to separate your frontend web (web application logic) from backend SAS (data access and manipulation logic). For this you can use the open source Boemska h54s adapter. I have written two guides to building web apps this way - a short one and a more detailed one. Boemska even have a free application (the HOT editor) on github which may serve your initial requirements - https://github.com/Boemska/sas-hot-editor Note that the tool above will only work with SAS datasets, and does a complete replace (destroying indexes etc) of the backend table each time. For a complete solution, there are many more considerations. Such as: - handling of numerical precision and special characters - dynamically handling different data types (strings / numerics / dates / datetimes) - loading target tables of different types (retained keys, composite keys, scd2, bitemporal) You will also need to work with a database, or SAS Share (rather than SAS datasets) to enable concurrent access from multiple users. If you'd like to truly delight your users / developers / admins (and save yourself several years of development and testing, as well as avoiding a custom build), I'd urge you to consider the Macro People Data Controller. This is a Stored Process Web App with the following features: - Secure, Real Time data uploads - All changes routed through an approval mechanism (approver signs off changes and then they are applied) - Full audit history (what changed, when, by whom with reason capture) - Alerts - Documentation (user guide, admin guide) - Secured with SAS Metadata - Extensively battle tested PM for a no obligation demo!
... View more