Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Frequency time series on SAS Visual Analytics requires compress count by month

Reply
Contributor
Posts: 21

Frequency time series on SAS Visual Analytics requires compress count by month

I have two columns, one as Acutal_date and another as Incident_ID

Actual_date    Incident_ID
12/02/2014      W23421
02/12/2015      W234234

I want to create a simple time series plot in SAS VA that displays count by Month-Year. For example, Feb-2014 == count as 1, Mar-2014 == count as 0 ... I refomart the Actual_date variable into MMYYYY, but when I do the time series plot, the count doesn't compress as Month-Year, but still actual dates, so I get a lot of 1's across the board.

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