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

Changing measure to category upon loading the lasr

Accepted Solution Solved
Reply
Highlighted
Frequent Contributor
Posts: 80
Accepted Solution

Changing measure to category upon loading the lasr

Hello and I apologize in advance if this post is not belong to this section and I will be happy to post it into its own group. I want to know if I do have a control on a column type when I load data into lasr. Foe example let's say my table contains an id column, name and address. When I load the table into lasr my id column as the default is set to measure. I know I can go ahead in report or data explore change it to category but every time I try to use it in a new report the default is measure. Is there a way to set it to category at all time? Thanks again

Accepted Solutions
Solution
‎02-24-2018 04:03 PM
Super User
Posts: 3,918

Re: Changing measure to category upon loading the lasr

One option would be to create an intermediate load table in SAS with the ID column converted then load that into VA. In my experience it is better to get your data organised properly outside of VA before loading rather than to try and "fix" it once it is in VA. This improves performance as well.

View solution in original post


All Replies
Super User
Posts: 3,918

Re: Changing measure to category upon loading the lasr

I suspect your ID column is numeric. Change it to character and reload it into the LASR server and it will be treated as a category.

Frequent Contributor
Posts: 80

Re: Changing measure to category upon loading the lasr

Thank you @SASKiwi, so the only way this will work is for me to change the property of original table column!  it is going to be hard to do that because (for example) I can't change the foreign key of the original table.  Not sure if possible to change the properties in the Metadata library where I register the table from SQL?

thank you again for your info and help.

Solution
‎02-24-2018 04:03 PM
Super User
Posts: 3,918

Re: Changing measure to category upon loading the lasr

One option would be to create an intermediate load table in SAS with the ID column converted then load that into VA. In my experience it is better to get your data organised properly outside of VA before loading rather than to try and "fix" it once it is in VA. This improves performance as well.

Frequent Contributor
Posts: 80

Re: Changing measure to category upon loading the lasr

Hi @SASKiwi, agree with you and again thank you for your time and info.

 

Best

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 517 views
  • 1 like
  • 2 in conversation