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!
One approach would be to create a calculated measure using the Parse() operator:
Parse('ZIP'n, 'F12.')
This should give you a measure output.
One approach would be to create a calculated measure using the Parse() operator:
Parse('ZIP'n, 'F12.')
This should give you a measure output.
Sam,
This is working perfectly!!!. You saved me at least working 1 day!! Thanks a lot for your incredible fast answer too.
Great! Thanks for following up with us.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.