topic Re: How to delete the Rows which are not required in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214105#M16095 <HTML><HEAD></HEAD><BODY><P>I think you need to explain a bit more. If you actually want to remove these rows then it's easiest to add a filter which would be a WHERE clause, otherwise you can try with a CASE function. The CASE function will not delete rows.</P><P></P><P>Case when quantity ne . then 0</P><P>when quantity eq . then .</P><P>end </P></BODY></HTML> Thu, 30 Jul 2015 14:37:10 GMT Reeza 2015-07-30T14:37:10Z How to delete the Rows which are not required https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214104#M16094 <HTML><HEAD></HEAD><BODY><P>Hi, If i have 3 columns like material, quantity and week. Now I have to create a new column in which i do not require the data for which quantity is not available. How to to that? Kindly let me know . Also as i am not using coding so i would appreciate if you can help me in creating this in advance expression in the commutated columns of query builder.</P><P>Thanks</P><P>Sanchit</P></BODY></HTML> Thu, 30 Jul 2015 13:31:25 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214104#M16094 SanchitArora 2015-07-30T13:31:25Z Re: How to delete the Rows which are not required https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214105#M16095 <HTML><HEAD></HEAD><BODY><P>I think you need to explain a bit more. If you actually want to remove these rows then it's easiest to add a filter which would be a WHERE clause, otherwise you can try with a CASE function. The CASE function will not delete rows.</P><P></P><P>Case when quantity ne . then 0</P><P>when quantity eq . then .</P><P>end </P></BODY></HTML> Thu, 30 Jul 2015 14:37:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214105#M16095 Reeza 2015-07-30T14:37:10Z Re: How to delete the Rows which are not required https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214106#M16096 <HTML><HEAD></HEAD><BODY><P>Hey thanks a lot...filter make it working which i needed..</P></BODY></HTML> Thu, 30 Jul 2015 15:09:40 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-delete-the-Rows-which-are-not-required/m-p/214106#M16096 SanchitArora 2015-07-30T15:09:40Z