topic to retain values in SAS Programming

How to retain vales

r3570 — Fri, 17 Mar 2023 04:02:15 GMT

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

to retain values

r3570 — Fri, 17 Mar 2023 05:44:20 GMT

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

Re: How to retain vales

Kurt_Bremser — Fri, 17 Mar 2023 06:49:36 GMT

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

Re: to retain values

Kurt_Bremser — Fri, 17 Mar 2023 06:52:55 GMT

Please do not double-post.

Re: How to retain vales

s_lassen — Fri, 17 Mar 2023 07:31:12 GMT

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