topic Re: How to duplicate an observation for the same record ID? in SAS Studio

How to duplicate an observation for the same record ID?

emma19901 — Tue, 11 Dec 2018 22:42:58 GMT

Hi, I am working with a dataset that collected some body measurements., I would like to duplicate the observation on the same row to do a pre-treatment and post-treatment analysis. For example, having 1.2 again for record one. This a large dataset and doing this by hand or if-then statements is near to impossible.

record	measure A
1	1.2
1	.
2	1.3
2	1.3
3	.
3	.

Re: How to duplicate an observation for the same record ID?

novinosrin — Tue, 11 Dec 2018 22:48:30 GMT

data have;
input record	measure_A;
cards;
1	1.2
1	.
2	1.3
2	1.3
3	.
3	.
;
data want;
update have(obs=0) have;
by record;
output;
run;

Re: How to duplicate an observation for the same record ID?

Reeza — Tue, 11 Dec 2018 22:49:48 GMT

What exactly do you want as output?

1.3 filled down? What about Record 3s? Are both missing there? Should they stay missing or take the previous value?

Please show what you start with and what you want as output.

@emma19901 wrote:

Hi, I am working with a dataset that collected some body measurements., I would like to duplicate the observation on the same row to do a pre-treatment and post-treatment analysis. For example, having 1.2 again for record one. This a large dataset and doing this by hand or if-then statements is near to impossible.

record measure A

1 1.2

1 .

2 1.3

2 1.3

3 .

3 .

Re: How to duplicate an observation for the same record ID?

r_behata — Tue, 11 Dec 2018 22:56:12 GMT

Is this what you are looking for ?

data want;
	set have;
	by record;
	retain measure_a_;
	if first.record then measure_a_=measure_a;

	if missing(measure_a) then measure_a=measure_a_;

	drop measure_a_;
run;

Re: How to duplicate an observation for the same record ID?

emma19901 — Tue, 11 Dec 2018 23:10:44 GMT

Yes, but is not working

Re: How to duplicate an observation for the same record ID?

emma19901 — Tue, 11 Dec 2018 23:12:01 GMT

After duplicating the values by record the missing data will be deleted., I can not do it before because I will lose the records of interest.

Re: How to duplicate an observation for the same record ID?

Reeza — Tue, 11 Dec 2018 23:15:54 GMT

It's not quite clear what you're trying to do. You can use OUTPUT to control the writing of records to an output step. So assuming you want to duplicate every record without a measure_A value, this has two output statements, which gives you two records.

Note the output statement causes implicit outputs to stop, so you have to explicitly specify when you want a record written to the data set.

data want;
set have;
if not missing(measure_A) then do;
output;output;
end;

run;

@emma19901 wrote:

After duplicating the values by record the missing data will be deleted., I can not do it before because I will lose the records of interest.

Re: How to duplicate an observation for the same record ID?

novinosrin — Tue, 11 Dec 2018 23:16:36 GMT


data have;
input record	measure_A;
cards;
1	1.2
1	.
2	1.3
2	1.3
3	.
3	.
;
data want;
update have(obs=0) have;
by record;
if measure_a>. then output;
run;

Re: How to duplicate an observation for the same record ID?

r_behata — Wed, 12 Dec 2018 00:58:42 GMT

How should your expected output look like ?

Re: How to duplicate an observation for the same record ID?

mkeintz — Wed, 12 Dec 2018 05:16:35 GMT

@emma19901

Help us help you. Please show the layout of the desired result data.