DATA Step, Macro, Functions and more

Report with user input

Accepted Solution Solved
Reply
Contributor
Posts: 55
Accepted Solution

Report with user input

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.

 

 


Accepted Solutions
Solution
‎11-17-2016 04:22 AM
Respected Advisor
Posts: 3,893

Re: Report with user input

[ Edited ]

 

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.

View solution in original post


All Replies
Solution
‎11-17-2016 04:22 AM
Respected Advisor
Posts: 3,893

Re: Report with user input

[ Edited ]

 

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 174 views
  • 0 likes
  • 2 in conversation