topic Re: Trying to calculate percentage as an advanced expression in query builder in SAS Programming https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127536#M294452 <HTML><HEAD></HEAD><BODY><P>yes it is in EG, geez, where is that forum, i wil look, thank you!</P></BODY></HTML> Tue, 29 Oct 2013 18:49:45 GMT Aalcorn 2013-10-29T18:49:45Z Trying to calculate percentage as an advanced expression in query builder https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127534#M294450 <HTML><HEAD></HEAD><BODY><P>I am no where as advanced as you guys, I am trying to figure percentages as one of my table fields/another table field-was trying to do this as an advanced expression to give me a percentage.. can anyone assist in the correct language? would be much appreciated, i am still new to this, thanks!</P><P></P><P>ex: t1.NCOVD_CHRG_AMT/t1.TOT_CHRG</P><P>that's what i was using as advanced expression (don't laugh pls)</P><P></P><P>then i got error</P><P><SPAN style="color: #ff0000;">_______</SPAN></P><P></P><P><SPAN style="color: #ff0000;">22</SPAN></P><P><SPAN style="color: #ff0000;">76</SPAN></P><P><SPAN style="color: #ff0000;">Error 22-322: syntax error, expecting one of the following: ',', Group, Having, Order, Where.</SPAN></P><P><SPAN style="color: #ff0000;">error, statement will be ignored</SPAN></P></BODY></HTML> Tue, 29 Oct 2013 18:12:41 GMT https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127534#M294450 Aalcorn 2013-10-29T18:12:41Z Re: Trying to calculate percentage as an advanced expression in query builder https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127535#M294451 <HTML><HEAD></HEAD><BODY><P>So this is in EG? You may want to post it in that forum.&nbsp; </P><P>What version of EG and can you provide more details on your data and calculation, and the full code that causes the error. </P><P>Usually its straight division and then apply a format of percent to the data.</P></BODY></HTML> Tue, 29 Oct 2013 18:45:54 GMT https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127535#M294451 Reeza 2013-10-29T18:45:54Z Re: Trying to calculate percentage as an advanced expression in query builder https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127536#M294452 <HTML><HEAD></HEAD><BODY><P>yes it is in EG, geez, where is that forum, i wil look, thank you!</P></BODY></HTML> Tue, 29 Oct 2013 18:49:45 GMT https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127536#M294452 Aalcorn 2013-10-29T18:49:45Z Re: Trying to calculate percentage as an advanced expression in query builder https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127537#M294453 <HTML><HEAD></HEAD><BODY><P>Aalcorn,</P><P></P><P>It is obvious that there is no syntax error in the excerpt of code you posted.</P><P>It would not be possible to help you, unless you provide more, preferably all, query code.</P></BODY></HTML> Tue, 29 Oct 2013 20:36:15 GMT https://communities.sas.com/t5/SAS-Programming/Trying-to-calculate-percentage-as-an-advanced-expression-in/m-p/127537#M294453 Marina 2013-10-29T20:36:15Z