Page 1 of 1

Valueset from external Dictionnary refus to export with label.

Posted: May 2nd, 2020, 5:30 am
by Gillesbop
Hello,
For the valueset, I had to use an external dictionary to classify them and read the combination of the corresponding values from this external dictionary.

When exporting data, the labels are not there. There are only numeric codes.

So how do I get it to export, I have both the codes and the labels?

Ps: The export is done in stata format.

Re: Valueset from external Dictionnary refus to export with label.

Posted: May 4th, 2020, 12:51 am
by btri Arjun
Did you fill up the values and label in the internal/main dictionary? If not copy and pest the label from external dictionary to main dictionary or add the values and try again.

Re: Valueset from external Dictionnary refus to export with label.

Posted: May 8th, 2020, 10:42 am
by Gregory Martin
One thing people do is export data using a batch program. In this program, you can lookup the labels and then export the label (as text) along with your data. In short, you can:

1) Define your export in the Export Data tool.

2) Select Options -> Copy Logic to Clipboard.

3) Paste that logic into a batch application.

4) Before the export statement, load the labels from your external dictionary.

5) Add the item that has the label to the export statement.

Let us know if you have questions on this approach.