Generating a new variable that contains only some values of other variables

[Daniel Perez]

Dear all,

I have a set of variables (i.e., v1 to V) from which I would like to extract some single summarized data (i.e., the median). With the data retrieved from each variable, I would like to generate a new single variable that keeps the summarized data organized in several observations (as the number of variables).

Any idea on how to proceed?

Thank you in advance.

[Felix Bittmann]

This sounds like a job for collapse or egen. So you could do the following:

sysuse auto, clear
egen medprice = median(price)

You could then write a loop and iterate over all variables of interest.

[Daniel Perez]

Thank you, Felix, I will try this way.