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.
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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.