12-09-2014 08:35 AM
I have a data set like customer name and month wise count. (In starting third month they have introduced one scheme i want to find out whether the scheme is impacting the next month counts i.e is there are any decrease or increase in mar apr month counts. I want to highlight those records.)
Custname Jan Feb Mar Apr
pvr 15 20 5 4
adlabs 20 30 40 50
imax 15 25 5 4
cinemax 29 35 7 6
like this i have one lakh customers and four months count.
I want to see based on Jan Feb count is there any trend in Mar Apr.
Suppose lets take PVR Jan feb it has increase but in march, apr it has decreased same as cinemax. Adlabs is increasing like that.
I want to highlight those customers. Any thoughts/logic.
12-09-2014 08:52 AM
Well, I would struggle to put logic in place there as its not a clear yes/no logic. What you are talking about is trend analysis: Trend analysis - Wikipedia, the free encyclopedia
Now I am not familiar enough to provide exact information, but there is material out there. This for instance may be of help:
So, and this is something I do, you can produce graphs of individual values/means and also an overall graph of means/mins/maxs. That would visually show you where things change e.g. you would have a drop in the line for Mar/Apr for lines PVR and Cinemax. You could maybe also use that information (i.e. output from proc means) to do some logic gates.
12-09-2014 10:10 AM
Regardless of trend analysis technique, I think you are better off transposing your data (having Custname, Month and Count as columns).