Hi,

I am a very new user in Stata and need help with obtaining only relevant correlation coefficients when running pwcorr or spearman commands.

Example:
I have the following variables in my data set: Weight-a, Weight-b, BMI-a, BMI-b, Hight-a, Hight-b
I want to get the following table directly:
Variable r-value
Weight* 1.0
BMI 1.0
Hight 0.9
*for the correlation between Weight-a and -b, etc

Is there any way to get the table above instead of getting the traditional one where every single variable is compared to all other ones?