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

Change variable Clasification option from "Category" to "Measure" in Visual Analytics

Accepted Solution Solved
Reply
New Contributor EBB
New Contributor
Posts: 4
Accepted Solution

Change variable Clasification option from "Category" to "Measure" in Visual Analytics

I have a numeric variable that has been assigned to the clasification role "Category" in a data mart in VA. I noticed that "category" variables cant be changed to "measures" and this is actually my problem. I need this numeric variable to be a "measure" to be able to use it as input for a slider (slider object only takes "measures" variables as input) on a report I'm building in Visual Analytics designer mode.

 

Does anybody knows hoy to change one variable clasification from "category" to "measure" without having to rewrite the proc sql that is generatin the data mart beeing loaded in VA?

 

Thanks a lot! 


Accepted Solutions
Solution
‎05-17-2016 02:54 AM
SAS Super FREQ
Posts: 289

Re: Change variable Clasification option from "Category" to "Measure" in Visual

One approach would be to create a calculated measure using the Parse() operator:

 

Parse('ZIP'n, 'F12.')

 

This should give you a measure output.

View solution in original post


All Replies
Solution
‎05-17-2016 02:54 AM
SAS Super FREQ
Posts: 289

Re: Change variable Clasification option from "Category" to "Measure" in Visual

One approach would be to create a calculated measure using the Parse() operator:

 

Parse('ZIP'n, 'F12.')

 

This should give you a measure output.

New Contributor EBB
New Contributor
Posts: 4

Re: Change variable Clasification option from "Category" to "Measure" in Visual

Sam,

 

This is working perfectly!!!. You saved me at least working 1 day!! Thanks a lot for your incredible fast answer too.  

SAS Super FREQ
Posts: 289

Re: Change variable Clasification option from "Category" to "Measure" in Visual

Great! Thanks for following up with us.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 544 views
  • 2 likes
  • 2 in conversation