Business Analysis Functions without code or Using in-built functions and adding extra code.

[sridhar78]

I learnt that SAS is one of the most powerful tools for data or business analysis.

It also have plenty of options or features to customize/code to get the required output.

But real life business problems may require quick solutions to know

1) top X customers

2) highest order value

3) frequently sold product

Are there in-built functions for filtering or sorting and getting the required results ? For instance name of the customer with highest revenues.

Is there a way I can use an in-built function and further customize it using code?

[LinusH]

Yes to all. Works different in the different SAS tools/applications.

If you are an existing SAS customer, what tools do you license?

If not, what kind of analysis do you need (conducted by whom, consumed by whom)?

[sridhar78]

I'm using SAS Ent. Guide 4.3.

Can I do sorting, filtering, regular stat or math calculations using menus?

[kuridisanjeev]

Yes Sridhar,

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.

Regards,

Sanjeev.K

[sridhar78]

Thanks Sanjeev for clarifying.

[kuridisanjeev]

For Your reference.

http://support.sas.com/resources/papers/proceedings11/305-2011.pdf

Regards,

Sanjeev.K