Stored Process Server - Editable Dataset - Possible?

[arunrami]

Hi @boemskats  Thanks for you suggestions, I am going to follow your idea, hope our admin team will provide access to import file to webserver.

[boemskats]

Hi Jim,

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 🙂

Nik

[Jim_O_CCCU]

Hi Nik,

The forum was awesome thanks. I will check that out and PM you should it fit the bill. 😎

Jim

[Jim_O_CCCU]

Hi all,

We opted for a hybrid approach in the end.

1. Used Base SAS to produce a dataset containing my key info fields and the blank fields that the users need to populate - output as an MS Access database table

2. Developed an MS Access front end, linked to the table from (1), hosted on a organisational shared drive to do handle the data input, access control, auditing and validation

3. Built and scheduled a SAS VA report over the MS Access table to give an up to date picture of data entry progress and MI on what the gathered data was telling us

Thanks for your input on the other potential solutions

Jim