Replace Numeric value with alpha in show function

[khurshid.arshad]

Dear Gregory;

I am using Show function. Can we replace numeric values with Alpha for display only For example:

PersonID, Name, Sex, Relation
1 arshad 1 1
2 almas 2 2

Now i want
"Male" against 1 and "Female" against 2 under Sex title
Household head against 1 and "Spouse" against 2 under relation title.

Data is numeric in my external data file.

Take care.
Arshad

[khurshid.arshad]

Dear Gregory;

Any update about my query.
arshad

[Gregory Martin]

I answered Arshad in person, but for those following this thread, the answer is that there is no way to replace the numeric value with the label from the value set using the show function. There would be two options to get around this:

1) Use dynamic value sets instead, customizing the value label to include all the relevant information.

2) Add an alpha field to the roster that will contain the value label. For example, you could add an alpha item SEX_LABEL that contains the value set label for the SEX code (retrieved using the getlabel function). Unfortunately, this data would also get saved to your data file, which may not be desirable.