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

Sort Schedule Chart in SAS VA 7.3

Reply
Contributor
Posts: 69

Sort Schedule Chart in SAS VA 7.3

Hi I'm trying to make a schedule chart in SAS VA. 

I have struggling with getting the sort right in a Gantt chart sense.

Here is the default I get.

Schedule Chart Task.png

I really want this sorted by start date within the Lattice rows.

 

I can achieve this by creating a dummy counter by sorting the data by descending start date and add the counter

Schedule Chart Task3.png

There are a couple of drawbacks. It does not allow a BI user to just import from spreadsheet where this sort of data typically is managed. Further it will be hard to use this as a report driller object as the task name will then have to be superseeded with the counter in all other data sets.

 

Anybody has an idea.

 

Data is provided below.

data LRP_TIMELINE;
  infile datalines dsd truncover;
  input CATEGORY:$7. TASK:$20. START:DATE9. END:DATE9. task2:$200. task3:$200.;
datalines4;
RNB,Reviews,21SEP2018,30SEP2018,22-Reviews,01-Reviews
Review,GM and President,20SEP2018,27SEP2018,21-GM and President,02-GM and President
RNB,Analysis,03SEP2018,20SEP2018,20-Analysis,03-Analysis
Finance,Economic Calculation,29AUG2018,12SEP2018,17-Economic Calculation,04-Economic Calculation
Finance,Presentation,29AUG2018,15OCT2018,18-Presentation,05-Presentation
RNB,Template upload,29AUG2018,02SEP2018,19-Template upload,06-Template upload
Finance,Template upload,27AUG2018,29AUG2018,16-Template upload,07-Template upload
GEA,Reviews,01AUG2018,23AUG2018,15-Reviews,08-Reviews
GEA,Reviews,15JUN2018,30JUN2018,14-Reviews,08-Reviews
GEA,Optimization,01MAY2018,15JUN2018,13-Optimization,10-Optimization
Review,Refine Processes,05APR2018,20APR2018,12-Refine Processes,11-Refine Processes
Finance,Metric Template,20MAR2018,09APR2018,10-Metric Template,12-Metric Template
Review,,20MAR2018,04APR2018,11,13
POA,Template upload,06MAR2018,09MAR2018,09-Template upload,14-Template upload
Other,Other3,01MAR2018,29APR2018,08-Other3,15-Other3
POA,Reviews,23FEB2018,05MAR2018,07-Reviews,16-Reviews
GEA,LTF,15FEB2018,01MAY2018,06-LTF,17-LTF
POA,Update,05FEB2018,22FEB2018,05-Update,18-Update
GEA,Premises,01FEB2018,01MAR2018,03-Premises,19-Premises
POA,Premises,01FEB2018,15FEB2018,04-Premises,20-Premises
Other,Economic Analysis,01JAN2018,28FEB2018,01-Economic Analysis,21-Economic Analysis
Other,Other 2,01JAN2018,19APR2018,02-Other 2,22-Other 2
;;;;

 

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