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.
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.
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.
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.