topic Creating new variable in a longitudinal dataset in SAS Programming

Creating new variable in a longitudinal dataset

tbanh — Mon, 17 Jun 2019 16:09:04 GMT

Hello, I have searched for the answer to my problem but to no avail. I have a longitudinal dataset that looks like this:

Each subject currently has five repeated measures (at time points 0-4). I would like to take the variable on the left ("recall_trial6") and append it the variable on the right ("recall"), in essence, adding a repeated measure. At the same time, I would need to add another time point to "trial" so that it runs from 0-5. Any help or tips are greatly appreciated!

Re: Creating new variable in a longitudinal dataset

Reeza — Mon, 17 Jun 2019 16:11:32 GMT

Given the expected input above, please show the expected output.

Re: Creating new variable in a longitudinal dataset

tbanh — Mon, 17 Jun 2019 16:31:00 GMT

Subject Trial Recall

1 0 9

1 1 14

1 2 19

1 3 21

1 4 20

1 5 23

2 0 4

2 1 7

2 2 11

2 3 13

2 4 16

2 5 12

... ... ...

Re: Creating new variable in a longitudinal dataset

Reeza — Mon, 17 Jun 2019 18:56:04 GMT

data want;
set have;

by id;
output;

if last.id then do;
   trial = 5;
   recall=recall_trial6;
    output;
end;

*keep id trial recall;

run;

This should work then.

@tbanh wrote:

Hello, I have searched for the answer to my problem but to no avail. I have a longitudinal dataset that looks like this:

Each subject currently has five repeated measures (at time points 0-4). I would like to take the variable on the left ("recall_trial6") and append it the variable on the right ("recall"), in essence, adding a repeated measure. At the same time, I would need to add another time point to "trial" so that it runs from 0-5. Any help or tips are greatly appreciated!