Hello,
I need to develop a dynamic prompt that offers this :
Do you have any example codes that might help ??
Many thanks
We have a web application (free for 5 users) that gives you exactly this, and a lot more - it's called Data Controller for SAS
It supports special SAS missing numerics, uploads from Excel, changes to CAS tables / any database, and can even let you change the values in a format catalog. It works on both SAS 9 and Viya. All changes are tracked, and you can set permissions at row level (who can change what). You can also defined data quality rules, and trigger additional jobs when tables are modified.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.