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

[EBB]

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! 

[Sam_SAS · Accepted solution]

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

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

This should give you a measure output.

[EBB]

Sam,

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

[Sam_SAS]

Great! Thanks for following up with us.