topic Re: how do I get value form a event row to event row where value is missing? in SAS Programming

how do I get value form a event row to event row where value is missing?

Dhana18 — Sun, 14 Mar 2021 03:51:49 GMT

Hi I have a data like this:

data have;

input ID EventID Male $ Female $ MTF $ FTM $;

datalines;

1 1 male

1 2

1 3 male

2 1 female

2 2 female

2 3

3 1 mtf

3 2

3 3 Mtf

run;

I want it to be:

1 1 male

1 2 male

1 3 male

2 1 female

2 2 female

2 3 female

3 1 mtf

3 2 mtf

3 3 mtf

data want;
do until(last.Ieventid);
set have;
length m $4;
length f $6;
length mtf $14;
length ftm $14;
by eventid;
M=Catx('' , Male);
F=Catx('' , Female);
mtf=Catx('' , mtf);
end;
run;

Re: how do I get value form a event row to event row where value is missing?

mkeintz — Sun, 14 Mar 2021 04:24:15 GMT

Please provide your HAVE dataset in a working data step. Otherwise we are left to guess what your data really look like.

And provide a working WANT data step as well.

Help us help you.

Re: how do I get value form a event row to event row where value is missing?

Ksharp — Sun, 14 Mar 2021 10:40:37 GMT

data have;
input ID EventID Male $ Female $ MTF $ FTM $;
datalines;
1 1 male . . .
1 2 . . . .
1 3 male . . .
2 1   . female . .
2 2   . female . .
2 3  . . . .
3 1  . .        mtf .
3 2  . . . .       
3 3  . .      mtf .
;
run;
data want;
 update have(obs=0) have;
 by id;
 output;
run;

Re: how do I get value form a event row to event row where value is missing?

Dhana18 — Mon, 15 Mar 2021 01:16:30 GMT

Thank you!