topic Re: Business Analysis Functions without code or Using in-built functions and adding extra code. in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89080#M25399 <HTML><HEAD></HEAD><BODY><P>I'm using SAS Ent. Guide 4.3. </P><P>Can I do sorting, filtering, regular stat or math calculations using menus?</P></BODY></HTML> Thu, 03 Oct 2013 08:53:35 GMT sridhar78 2013-10-03T08:53:35Z Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89078#M25397 <HTML><HEAD></HEAD><BODY><P>I learnt that SAS is one of the most powerful tools for data or business analysis. </P><P>It also have plenty of options or features to customize/code to get the required output. </P><P>But real life business problems may require quick solutions to know</P><P>1) top X customers</P><P>2) highest order value</P><P>3) frequently sold product</P><P></P><P>Are there in-built functions for filtering or sorting and getting the required results ? For instance name of the customer with highest revenues.</P><P></P><P>Is there a way I can use an in-built function and further customize it using code? </P></BODY></HTML> Fri, 20 Sep 2013 10:40:55 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89078#M25397 sridhar78 2013-09-20T10:40:55Z Re: Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89079#M25398 <HTML><HEAD></HEAD><BODY><P>Yes to all. Works different in the different SAS tools/applications.</P><P>If you are an existing SAS customer, what tools do you license?</P><P>If not, what kind of analysis do you need (conducted by whom, consumed by whom)?</P></BODY></HTML> Fri, 20 Sep 2013 10:46:04 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89079#M25398 LinusH 2013-09-20T10:46:04Z Re: Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89080#M25399 <HTML><HEAD></HEAD><BODY><P>I'm using SAS Ent. Guide 4.3. </P><P>Can I do sorting, filtering, regular stat or math calculations using menus?</P></BODY></HTML> Thu, 03 Oct 2013 08:53:35 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89080#M25399 sridhar78 2013-10-03T08:53:35Z Re: Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89081#M25400 <HTML><HEAD></HEAD><BODY><P>Yes Sridhar,</P><P></P><P>You can perform sorting, filtering and many actions by Using Query builders in SAS EG with out writing any SAS Code.Even you can get the code from performed query builders as well.</P><P></P><P></P><P>Regards,</P><P></P><P>Sanjeev.K</P></BODY></HTML> Thu, 03 Oct 2013 09:20:42 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89081#M25400 kuridisanjeev 2013-10-03T09:20:42Z Re: Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89082#M25401 <HTML><HEAD></HEAD><BODY><P>For Your reference.</P><P></P><P><A href="http://support.sas.com/resources/papers/proceedings11/305-2011.pdf" title="http://support.sas.com/resources/papers/proceedings11/305-2011.pdf">http://support.sas.com/resources/papers/proceedings11/305-2011.pdf</A></P><P></P><P></P><P>Regards,</P><P></P><P>Sanjeev.K</P></BODY></HTML> Thu, 03 Oct 2013 09:24:12 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89082#M25401 kuridisanjeev 2013-10-03T09:24:12Z Re: Business Analysis Functions without code or Using in-built functions and adding extra code. https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89083#M25402 <HTML><HEAD></HEAD><BODY><P>Thanks Sanjeev for clarifying. </P></BODY></HTML> Thu, 03 Oct 2013 09:36:03 GMT https://communities.sas.com/t5/SAS-Procedures/Business-Analysis-Functions-without-code-or-Using-in-built/m-p/89083#M25402 sridhar78 2013-10-03T09:36:03Z