I have the following data and would like to be able to track project tasks and deliverables by analyst. What is the best way to structure the data and how do I do it?
Start by posting the data in usable form: a data step using datalines, then we have something to work with. You have to show / explain what you expect as result.
Providing the data as a SAS data step (and not in any other format), according to these instructions, would be very helpful.
Also, what is wrong (in your opinion) with this data structure, and also please provide concrete examples of what you mean by "track project tasks and deliverables by analyst".