Change variable value label in tables collect

[Eddy Simms]

This is part of a much larger dataset and unfortunately some of the value labels are quite long:

* Example generated by -dataex-. For more info, type help dataex
clear
input byte(age origin gender)
20 1 1
21 1 1
20 1 1
20 1 1
20 1 1
19 1 1
20 1 1
18 1 1
22 1 1
19 1 1
end
label values origin wafer
label def wafer 1 "Digital", modify
label values gender gender
label def gender 1 "F", modify
label var age "Age (Years) on day of surgery "
label var origin "Wafer "
label var gender "Gender"

Generating a table:

table (origin), stat(mean age) stat(p50 age) stat(min age) stat(max age) stat(fvrawfrequency gender) nformat(%6.2f  mean p50 min max)
collect label levels result fvrawfrequency "Frequency"  ///
                            mean                            "Mean"      ///
                            min                               "Minimum"   ///
                            max                              "Maximum"   ///
                            p50                                "p50"        ///
                            , modify
collect preview

I need to change the value label for age to 'Age'. I appreciate that I can change the label in the dataset but can I do it with collect?

Eddy

[Daniel Shin]

collect label levels var age "Age", modify
collect preview

[Eddy Simms]

Thank you.