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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.