Change numeric variables from category to measure in VA

raziel999 — Thu, 11 Jan 2018 10:41:55 GMT

Hello, I am having an issue with the categorisation of variables in categories and measures in VA.

I uploaded a table with a bunch of numeric fields I need to use as measures. When looking into the table in the report editor, a few of those variables are correctly listed as measures, and a few others are categorised as categories. I tried to convert those back into metrics using the parse function, but this is not working due to those variables already being numeric. I also tried to convert them to text and then parse (e.g. parse(format('variable1'n,'$.'),'F12.) but to no avail. In this latter case a measure is created but when added to charts/tables it gives no results.

Is there any other way to change those categories into metrics? Thanks

Re: Change numeric variables from category to measure in VA

FredrikE — Thu, 11 Jan 2018 11:34:27 GMT

Unless they are characters, you could just right-click them one at a time and select measure(Mått) instead of category(Kategori):

//Fredrik

topic Change numeric variables from category to measure in VA in SAS Visual Analytics

Change numeric variables from category to measure in VA

Re: Change numeric variables from category to measure in VA