To find outliers based on counts of case volumes on region wise and product wise

[doddalamadhulatha]

Hi,

I am using SAS Studio currently and have data with case_id ($) and open and close date (only numeric variables in the raw data) and all other related variables are with respect to region from which the case is recorded and the categories of the case recorded (like whether the case is hardware or software) and type of case resolution like remote resolve or onsite etc.

My question is how to find the outliers (here the maximum and minimum case volume count) against the region data or product data or like with resolution data. Please also mention sample code that help me a lot.

Thanks in advance.

Madhu

[ChrisNZ]

Provide example input/output data perhaps?

[doddalamadhulatha]

There are 95+ variables in which only two are continuous variables i.e open_date and Close_date (includes date, time with seconds) and all other like Case_Id, region, sub_region, product_line, business_unit, call_type, product, case _severity, month_name etc. I have to find the outliers based on case count against multiple variables from the given data both in tabular form and graphically over a given time period (say a fiscal Year). Hopes this helps. (I cant provide you the data as it is highly confidential).

Please provide me a sample code to generate this.