topic Re: Numerical Trends in SAS Data Science

Numerical Trends

Liban — Tue, 12 May 2015 14:13:42 GMT

Hi all

I need some assistance on this metric. The metric contains CustID, # of flags for 2015Q1, 2014Q4 & 2014Q1. How can I show numerical trends current quarter to prior quarter and current quarter to a year ago. My metric look like this

CustID	2015Q1_flags	2014Q4_flags	2014Q1_flags
0120029	2	2	2
0112595	5	4	4
0124448	26	27	7
0125189	2	2
0125782	1
0125792	2	2	1
0120443	45	42	14
0125963	4	7	2

Thanks in advance for your help.

Re: Numerical Trends

M_Maldonado — Wed, 13 May 2015 21:03:56 GMT

Hey Liban,

More info please. When you say you want to show the trend, do you mean you want to model the trend or explain the trend?

Or is this just a visualization exercise? what are you trying to do?

thanks,

Miguel

Re: Numerical Trends

Liban — Thu, 14 May 2015 01:05:49 GMT

Thanks Miguel,

what i am trying to show base on the # of flags for each client if the # of flags trending upward or downward without using visualization.I will welcome any suggestion on this.

Thanks,

Liban

Re: Numerical Trends

gergely_batho — Thu, 14 May 2015 01:56:54 GMT

Do you want to calculate the trend for each CustID?

Year_Trend = 2015Q1_flags - 2014Q1_flags

Qtr_Trend = 2015Q1_flags - 2014Q4_flags

Or are you looking for a statistical test, that shows whether there is a trend? (Paired T-test)

Re: Numerical Trends

Liban — Thu, 14 May 2015 02:06:00 GMT

Thanks Gergely,

I am looking for a statistical test and explain the trend?

Thanks,

Liban

Re: Numerical Trends

gergely_batho — Thu, 14 May 2015 06:33:50 GMT

Hi,

have a look at this PROC TTEST example:

SAS/STAT(R) 13.2 User's Guide