How to retain vales

[r3570]

Hi Team,

Request anyone to please kindly help with the below query.

I have a question where the data is as below:

TEST	RESULT	TIMEPOINT
FU-ABC-1298	4.5	6
FU-ABC-1298	0	0
FU-ABC-1299	7.5	6
FU-ABC-1299	0	0
ABC-1298
ABC-1298
ABC-1298
ABC-1298
ABC-1299
ABC-1299
ABC-1299
ABC-1299

My output should look like below:

TEST	RESULT	TIMEPOINT
FU-ABC-1298	4.5	6
FU-ABC-1298	0	0
FU-ABC-1299	7.5	6
FU-ABC-1299	0	0
ABC-1298	4.5
ABC-1298	4.5
ABC-1298	4.5
ABC-1298	4.5
ABC-1299	7.5
ABC-1299	7.5
ABC-1299	7.5
ABC-1299	7.5

[Kurt_Bremser]

So you want to replace missing values with the last available non-zero non-missing value for a group?

[r3570]

Hi Team,

Request anyone to please kindly help with the below query.

I have a question where the data is as below:

TEST	RESULT	TIMEPOINT
FU-ABC-1298	4.5	6
FU-ABC-1298	0	0
FU-ABC-1299	7.5	6
FU-ABC-1299	0	0
ABC-1298
ABC-1298
ABC-1298
ABC-1298
ABC-1299
ABC-1299
ABC-1299
ABC-1299

My output should look like below:

TEST	RESULT	TIMEPOINT
FU-ABC-1298	4.5	6
FU-ABC-1298	0	0
FU-ABC-1299	7.5	6
FU-ABC-1299	0	0
ABC-1298	4.5
ABC-1298	4.5
ABC-1298	4.5
ABC-1298	4.5
ABC-1299	7.5
ABC-1299	7.5
ABC-1299	7.5
ABC-1299	7.5

[Kurt_Bremser]

Please do not double-post.

[s_lassen]

Just one question: what does the TIMEPOINT variable do, and why is it mostly missing?