Report with user input

ANLYNG — Fri, 11 Nov 2016 20:30:32 GMT

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.

Re: Report with user input

Patrick — Sun, 13 Nov 2016 02:53:07 GMT

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.

topic Report with user input in SAS Programming

Report with user input

Re: Report with user input