Question

Kindly provide the data steps i really need them thanks and please answer the entire question /*Question 4: A doctor examines the growth of three kids. The following data is a record of those kids hight (meter) and weight (kg) collected at five different times. The first column is the ID of kids, the next five columns are the hight of kids, and the last five columns are the weight of kids. Please transform the data such that each kid has five observations and five columns showing, repectively, ID, time of measurement, height, weight, and BMI index. BMI is calculated as weight divided by the square of height. 1 0.9072 1.0080 1.1592 1.3356 1.5372 21.4545 26.9091 29.5455 36.2727 45.4545 2 0.7560 0.8316 0.9576 1.1088 1.2348 15.9091 18.1818 21.3636 25.4545 32.2727 3 0.8316 0.9324 1.1088 1.2348 1.3608 19.5455 27.2727 32.7273 39.5455 52.2727 */

Answer 1

ID	height	weight
1	0.9072 1.0080 1.1592 1.3356 1.5372	21.4545 26.9091 29.5455 36.2727 45.4545
2	0.7560 0.8316 0.9576 1.1088 1.2348	15.9091 18.1818 21.3636 25.4545 32.2727
3	0.8316 0.9324 1.1088 1.2348 1.3608	19.5455 27.2727 32.7273 39.5455 52.2727

1.

time of measurement	height	weight	BMI index
1	0.9072	21.4545	26.0682
2	1.0080	26.9091	26.4836
3	1.1592	29.5455	21.9874
4	1.3356	36.2727	20.3341
5	1.5372	45.4545	19.2360

2.

time of measurement	height	weight	BMI index
1	0.7560	15.9091	27.8356
2	0.8316	18.1818	26.2910
3	0.9576	21.3636	23.2973
4	1.1088	25.4545	20.7041
5	1.2348	32.2727	21.1661

3.

time of measurement	height	weight	BMI index
1	0.8316	19.5455	28.2629
2	0.9324	27.2727	31.3706
3	1.1088	32.7273	26.6197
4	1.2348	39.5455	25.9360
5	1.3608	52.2727	28.2284