04-19-2018 04:41 AM
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.
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
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 ;;;;