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

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

EBB — Fri, 13 May 2016 12:50:17 GMT

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!

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

Sam_SAS — Fri, 13 May 2016 13:54:41 GMT

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

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

This should give you a measure output.

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

EBB — Tue, 17 May 2016 06:54:34 GMT

Sam,

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

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

Sam_SAS — Tue, 17 May 2016 13:06:18 GMT

Great! Thanks for following up with us.