topic Re: Error whilst Filtering in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195055#M14855 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; background-color: #ffffff; text-decoration: line-through; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">t1.'Sum of Total Retail Price'n &lt; 'Salary'/ 0.5</SPAN></P><P><SPAN style="font-size: 13px; background-color: #ffffff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">t1.'Sum of Total Retail Price'n &lt; <STRONG>'Salary'n</STRONG>/ 0.5</SPAN></P></BODY></HTML> Tue, 14 Apr 2015 11:02:10 GMT gergely_batho 2015-04-14T11:02:10Z Error whilst Filtering https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195054#M14854 <HTML><HEAD></HEAD><BODY><P>I am using the Filter and Sort and put this code into the filter:</P><P></P><P>t1.'Sum of Total Retail Price'n &lt; 'Salary'/ 0.5</P><P></P><P>However, I keep on receiving this message:</P><P></P><P>ERROR: Expression using division (/) requires numeric types.</P><P></P><P>What am I doing wrong?</P></BODY></HTML> Tue, 14 Apr 2015 09:14:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195054#M14854 agreekgod 2015-04-14T09:14:26Z Re: Error whilst Filtering https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195055#M14855 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13px; background-color: #ffffff; text-decoration: line-through; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">t1.'Sum of Total Retail Price'n &lt; 'Salary'/ 0.5</SPAN></P><P><SPAN style="font-size: 13px; background-color: #ffffff; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">t1.'Sum of Total Retail Price'n &lt; <STRONG>'Salary'n</STRONG>/ 0.5</SPAN></P></BODY></HTML> Tue, 14 Apr 2015 11:02:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195055#M14855 gergely_batho 2015-04-14T11:02:10Z Re: Error whilst Filtering https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195056#M14856 <HTML><HEAD></HEAD><BODY><P>And, since salary is a perfect standard valid SAS variable name, omit the quotes completely:</P><P>t1.'Sum of Total Retail Price'n &lt; Salary/ 0.5</P></BODY></HTML> Tue, 14 Apr 2015 11:16:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195056#M14856 Kurt_Bremser 2015-04-14T11:16:50Z Re: Error whilst Filtering https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195057#M14857 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You remove the quotes and try hopefully it will work for you.</P><P>ex.</P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; background-color: #ffffff;">t1.'Sum of Total Retail Price'n &lt; (Salary / 0.5)</SPAN></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; background-color: #ffffff;"><BR /></SPAN></P><P>Yogesh</P></BODY></HTML> Tue, 14 Apr 2015 11:41:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-whilst-Filtering/m-p/195057#M14857 shubhayog 2015-04-14T11:41:37Z