02-16-2018 03:49 PM
Articles online said the same thing. I was hoping there was an easy way though. I am looking at relabeling seven hundred labels. I am going to look into scripting the labels in the Visual Analytics data preparation section. If I have a list of column names and what the label should be, I should be able to do a manual labeling from a semi manual script generation.
02-16-2018 04:04 PM - edited 02-16-2018 04:04 PM
If the variables in SAS and Oracle have the same names then it shouldn't be that hard to retrieve the labels from the SAS variables (i.e. using dictionary.columns) and then generate SQL alter table statements as Oracle Pass-Through code.
02-16-2018 04:48 PM
Why are you loading SAS data into Oracle and then reading it back into Visual Analytics as SAS data?
If you need Oracle data combined with SAS data, extract it into SAS first, build your VA load table in SAS (with labels) and load it into VA from there. That way you can keep your SAS labels without any problem.