Hi All
In my SAS Dataset that I have imported in SAS VA, I have a Categorical column which has ID values like 1,2,3...10. I have the corresponding ID to names mapping avaialble and would now need to map the ID number to ID name. Can we do this directly in SAS VA Report Designer? Could you help if not pssoible directly in SAS VA?
Thanks
Sid
Can you tell us more about why you need to map the two values?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Hi
The reason for the mapping is because I want specific names in the report filters INSTEAD of the IDs as shown currently. So basically would need to do a vlookup of the ID names for all the IDs rather than doing it manaully
Sid
How many discrete IDs do you need to map? If the number is small a report custom category would work and is easy to set up. If the number is large or changes dynamically based on your data then a SAS user-defined format is worth considering. This is more complicated to set up but is very flexible. User-defined formats are created outside of SAS VA using Base SAS.
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.