Generate a variable with IF AND

[Anastasiya Lu]

I need to crate a variable with IF AND formula, but I did not find it in Stata. Could you please help me how I can create a variable with this conditions?

[Rhys Williams]

Hi Anastasiya,

you can use the following type of command:

Gen variable = value if var2==value & var3==value

Best Rhys

[William Lisowski]

The equivalent to Excel's IF function

IF(x>y,"A","B")

is Stata's cond function

cond(x>y,"A","B")

The equivalent to Excel's AND function

AND(x>y,z>1)

is Stata's logical and operator &

x>y & z>1

[Anastasiya Lu]

Thank you a lot!

I wrote this code:

generate H = "A" if Y>= 1 & X >= 0.045
replace H = "B" if Y <= 1 & X >= 0.045
replace H = "C" if Y >= 1 & X <= 0.045
replace H = "D" if Y <= 1 & X <= 0.045

Y is crises variable, X is threshold.

But I need to write code, that if sum of Y Variable within the next 24 months is more (less) than 1, then .....
In Excel we can use sum of count using a loop or just sum(A1:A24). I need to have something like in Stata and place it in the code (sum of 24 Months of Y>= 1). Could you kindly help me how to figure out in Stata please.

[Nick Cox]

#4 is superseded by a new thread at https://www.statalist.org/forums/for...cells-a1-a24-0