Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA Categorical variable

Reply
Occasional Contributor
Posts: 5

SAS VA Categorical variable

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

SAS Super FREQ
Posts: 384

Re: SAS VA Categorical variable

Can you tell us more about why you need to map the two values?

Occasional Contributor
Posts: 5

Re: SAS VA Categorical variable

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

Respected Advisor
Posts: 2,913

Re: SAS VA Categorical variable

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. 

Post a Question
Discussion Stats
  • 3 replies
  • 115 views
  • 0 likes
  • 3 in conversation