Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Numerical Trends

Reply
Occasional Contributor
Posts: 5

Numerical Trends

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


CustID2015Q1_flags2014Q4_flags2014Q1_flags
0120029222
0112595544
012444826277
012518922
01257821
0125792221
0120443454214
0125963472


Thanks in advance for your help.

Super Contributor
Posts: 336

Re: Numerical Trends

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

Occasional Contributor
Posts: 5

Re: Numerical Trends

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

SAS Employee
Posts: 340

Re: Numerical Trends

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)

Occasional Contributor
Posts: 5

Re: Numerical Trends

Thanks Gergely,

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

Thanks,

Liban

SAS Employee
Posts: 340

Re: Numerical Trends

Hi,

have a look at this PROC TTEST example:

SAS/STAT(R) 13.2 User's Guide

Ask a Question
Discussion stats
  • 5 replies
  • 514 views
  • 0 likes
  • 3 in conversation