09-29-2017 01:26 PM
Last week I attended the SAS UK forum and was blown away by the possibilities of stored processes (amongst other things).
It has got me thinking about being a possible solution to a business need we have to allow editing/updating of a SAS dataset. Essentially, I want to show some of the columns in a dataset to the user via the web browser in a table, allow data to be entered into a column and then save that back to the underlying dataset.
So, am i proposing the impossible? Your advice would be greatly appreciated.
SAS 9.4 M3
09-29-2017 03:16 PM
You can do this.
To dig further into this, show an example of the underlying dataset and the changes you want to make in it.
09-30-2017 01:05 PM
Thanks for coming back.
The dataset is pretty simple, about 800 obs, 20 variables with a primary key. I want users to populate 3 numeric variables, the rest are text, I will display around 10 of the text variables to assist users.
Ideally, I'd like to show the 13 variables in a table, have the 3 numeric columns editable and have a save button to commit the changes back to the underlying SAS dataset.
10-03-2017 05:29 AM - edited 10-03-2017 05:32 AM
Bump - Hi Kurt, do you need more info?
I'm out of office at the time, meaning also that I have no viable access to "my" server. Will come back to you.
09-29-2017 08:08 PM
Are you after something like this? https://github.com/Boemska/sas-hot-editor
If you've got any questions please feel free to drop me a line. Glad you enjoyed the forum