DATA Step, Macro, Functions and more

Time Series Clustering

Reply
Contributor JS
Contributor
Posts: 38

Time Series Clustering

[ Edited ]

Hey,

 

I'm trying to do build a varying cluster for a set of records to see trends over different periods of time.

 

Ultimately my thoughts are that this will be exported to a CSV where I will be using pivot tables creating different visuals.

 

One excellent thing to keep in mind is that I will be doing this for many (~15 variables). So any sense of automation would be extremely helpful.2016-07-22_11-03-25.png

 

Have:

 

RecordVariableDate
1Mail1/1/2015
2Generic1/1/2015
3Paid Search1/1/2015
4Mail1/2/2015

 

Want:

 

VariableValueTime_RangeCount
CountTTD ApplicationsToday300
CountTTD ApplicationsWeek320
CountTTD ApplicationsMonthly350
CountTTD ApplicationsQuarter335
CountTTD ApplicationsAnnual290
ChannelMailToday300
ChannelMailWeek320
ChannelMailMonthly350
ChannelMailQuarter335
ChannelMailAnnual290
ChannelGenericToday300
ChannelGenericWeek320
ChannelGenericMonthly350
ChannelGenericQuarter335
ChannelGenericAnnual290
ChannelPaid SearchToday300
ChannelPaid SearchWeek320
ChannelPaid SearchMonthly350
ChannelPaid SearchQuarter335
ChannelPaid SearchAnnual290

 

 

 

Ask a Question
Discussion stats
  • 0 replies
  • 253 views
  • 0 likes
  • 1 in conversation