topic Re: how I structure this data in New SAS User

how I structure this data

urban58 — Mon, 19 Jul 2021 22:43:58 GMT

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

Re: how I structure this data

andreas_lds — Tue, 20 Jul 2021 06:31:46 GMT

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.

Re: how I structure this data

PaigeMiller — Tue, 20 Jul 2021 11:27:27 GMT

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