Generate a new variable using Min and Max

[Linda Lin]

Hi everyone,

Is there a way to generate a new variable by dividing the minimum and maximum values obtained from

summarize

?
I have tried...

 foreach x or variable1 variable2 variable3 egen {
egen ratio_`x'= max(`x')/min(`x')

...with no success

[Nick Cox]

There are several syntax errors there.

But even if that syntax worked you would just put a constant in the new variable.

This is legal if the variable names are real:

foreach x in variable1 variable2 variable3 { 
      su `x', meanonly 
      gen ratio_`x'  = r(max)/r(min) 
}

Is that what you want?

[Linda Lin]

There are several syntax errors there.

But even if that syntax worked you would just put a constant in the new variable.

This is legal if the variable names are real:

foreach x in variable1 variable2 variable3 {
su `x', meanonly
gen ratio_`x' = r(max)/r(min)
}

Is that what you want?

Yes, this is exactly what I was looking for. Thank you!