how I structure this data

[urban58]

Hello SAS community,

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?

					task variables				deliverable variables
id	repeat_instrument	repeat_instance	project_id	project_status	task_start_date	analyst	task_status	task_complete	deliverable	submission_status
1			AP-0001	5
1	task	1			9/10/2018	Chen, M	3	2
1	task	2			7/29/2020	Paul, D	3	2
2			AP-0002	1
2	task	1			2/6/2019	Sun Y	3	2
2	task	2			6/7/2019	Cody, B	1	2
2	task	3			6/26/2019	Cody, B	3	2
2	task	4			11/20/2019	Cody, B	3	2
2	task	5			11/20/2019	Cody, B	3	2
2	task	6			11/21/2019	Cody, B	3	2
2	task	7			11/21/2019	Cody, B	3	2
2	deliverable	1							1	2
2	deliverable	2							1	1
3			AP-0004	1
4			AP-0005	3
4	task	1			11/23/2020	Rawl, B	3	2
4	deliverable	1							9

Thanks,

Maggie

[andreas_lds]

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.

[PaigeMiller]

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".