topic Excel formula to SAS in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-formula-to-SAS/m-p/217382#M16355 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757;">HHi ,</SPAN></P><P><SPAN style="color: #575757;">i have a formula in excel</SPAN></P><P><SPAN style="color: #575757;">= (50/-10000) *30.4/(Z2-Y2)</SPAN></P><P><SPAN style="color: #575757;">when eh we work on dec data Z2-Y2 shd be nov - sep </SPAN></P><P><SPAN style="color: #575757;">sso the result shd be 30 days</SPAN></P><P><SPAN style="color: #575757;">can anyone help </SPAN></P></BODY></HTML> Tue, 07 Apr 2015 17:44:11 GMT chennupriya 2015-04-07T17:44:11Z Excel formula to SAS https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-formula-to-SAS/m-p/217382#M16355 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757;">HHi ,</SPAN></P><P><SPAN style="color: #575757;">i have a formula in excel</SPAN></P><P><SPAN style="color: #575757;">= (50/-10000) *30.4/(Z2-Y2)</SPAN></P><P><SPAN style="color: #575757;">when eh we work on dec data Z2-Y2 shd be nov - sep </SPAN></P><P><SPAN style="color: #575757;">sso the result shd be 30 days</SPAN></P><P><SPAN style="color: #575757;">can anyone help </SPAN></P></BODY></HTML> Tue, 07 Apr 2015 17:44:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-formula-to-SAS/m-p/217382#M16355 chennupriya 2015-04-07T17:44:11Z Re: Excel formula to SAS https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-formula-to-SAS/m-p/217383#M16356 <HTML><HEAD></HEAD><BODY><P>This would depend on your data structure, but in general the formula is exactly the same. Substitute the variable names in place of Z2 and Y2. </P></BODY></HTML> Tue, 07 Apr 2015 17:47:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Excel-formula-to-SAS/m-p/217383#M16356 Reeza 2015-04-07T17:47:41Z