Your SAS programs, embedded in web apps and elsewhere

Stored Process Server - Editable Dataset - Possible?

Reply
Occasional Contributor
Posts: 9

Stored Process Server - Editable Dataset - Possible?

Hi all,

 

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.

 

I have a fairly decent grasp of HTML, CSS and JavaScript to help in this.

 

So, am i proposing the impossible? Your advice would be greatly appreciated.

 

Thanks

 

Jim

SAS 9.4 M3

Super User
Posts: 7,431

Re: Stored Process Server - Editable Dataset - Possible?

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 9

Re: Stored Process Server - Editable Dataset - Possible?

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.

 

 

Regards

 

Jim

Occasional Contributor
Posts: 9

Re: Stored Process Server - Editable Dataset - Possible?

Bump - Hi Kurt, do you need more info?
Thanks

Jim
Super User
Posts: 7,431

Re: Stored Process Server - Editable Dataset - Possible?

[ Edited ]

Jim_O_CCCU wrote:
Bump - Hi Kurt, do you need more info?
Thanks

Jim

I'm out of office at the time, meaning also that I have no viable access to "my" server. Will come back to you.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Frequent Contributor
Posts: 97

Re: Stored Process Server - Editable Dataset - Possible?

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 Smiley Happy

 

Nik

Occasional Contributor
Posts: 9

Re: Stored Process Server - Editable Dataset - Possible?

Hi Nik,

 

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

 

Jim

Ask a Question
Discussion stats
  • 6 replies
  • 213 views
  • 2 likes
  • 3 in conversation