Report with user input

[ANLYNG]

I need to deliver a nice looking report with 10 text column(long and short text fields).But some  of the coloums should possible be updated by the users directly on the report or a form(?) on our SAS BI server portal.

Is there a smart simple way/ method for user input? and save it to the data. What do you recommend ? do you have some examples? Thanks in advance.

[Patrick · Accepted solution]

Assuming that your end-users want to be able to define some selection criteria, I'd go for a stored process with prompts.

There are quite a few options for prompts available. Read through the Stored Process docu if you're not already familiar with it.

You can even allow your users to add values to a selection list (but that bears the risk that they add something which then will break your job).

You can also provide table driven selection lists. If you want to take it further then you could allow selected users to amend such parameter tables via SAS AMO - but you probably would then also have to implement some parameter validation job in order to avoid that user input breaks your reporting job.