https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510148#M137268 I know case when but every time I should have to mentioned condition Sat, 03 Nov 2018 12:44:04 GMT thanikondharish 2018-11-03T12:44:04Z https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510145#M137265 By using<BR />if then do ;<BR />We can create multiple variables based on one condition but how to do create multiple variables based on one condition in sql Sat, 03 Nov 2018 12:33:03 GMT https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510145#M137265 thanikondharish 2018-11-03T12:33:03Z https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510147#M137267 <P>you could use Case when statements.</P> Sat, 03 Nov 2018 12:40:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510147#M137267 VDD 2018-11-03T12:40:48Z https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510148#M137268 I know case when but every time I should have to mentioned condition Sat, 03 Nov 2018 12:44:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510148#M137268 thanikondharish 2018-11-03T12:44:04Z https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510150#M137270 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/209685">@thanikondharish</a>&nbsp;wrote:<BR />I know case when but every time I should have to mentioned condition<HR /></BLOCKQUOTE> <P>And? That's SQL. If you want to use do/end blocks use a data step.</P> Sat, 03 Nov 2018 13:43:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-do/m-p/510150#M137270 Kurt_Bremser 2018-11-03T13:43:29Z