topic which technique to apply in SAS Data Management

which technique to apply

venkatnaveen — Tue, 09 Dec 2014 13:35:59 GMT

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.)

Dataset:
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.

Re: which technique to apply

RW9 — Tue, 09 Dec 2014 13:52:12 GMT

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:

SAS/ETS(R) 9.2 User's Guide

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.

Re: which technique to apply

LinusH — Tue, 09 Dec 2014 15:10:34 GMT

Regardless of trend analysis technique, I think you are better off transposing your data (having Custname, Month and Count as columns).