BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
L2Fly
Pyrite | Level 9
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
1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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

4 REPLIES 4
SASKiwi
PROC Star

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.

L2Fly
Pyrite | Level 9

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.

SASKiwi
PROC Star

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.

L2Fly
Pyrite | Level 9

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

 

Best

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Tips for filtering data sources in SAS Visual Analytics

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.

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