How to do

[thanikondharish]

By using
if then do ;
We can create multiple variables based on one condition but how to do create multiple variables based on one condition in sql

[VDD]

you could use Case when statements.

[thanikondharish]

I know case when but every time I should have to mentioned condition

[Kurt_Bremser]

---

@thanikondharish wrote:
I know case when but every time I should have to mentioned condition

---

And? That's SQL. If you want to use do/end blocks use a data step.