topic Re: merging multiple rows into 1 in SAS Programming

merging multiple rows into 1

purveshrana — Tue, 05 Sep 2017 13:16:45 GMT

I have a dataset

columns: A B C D

APPLE BALL 123 .

APPLE BALL . 123

I WANT AN OUTPUT TO BE LIKE FOLLOWING

A B C D

APPLE BALL 123 123

How can I solve this in single step ? Thanks

Astounding — Tue, 05 Sep 2017 13:29:05 GMT

If it takes just column A to determine a unique observation:

data want;

update have (obs=0) have;

by a;

run;

If it takes the combination of both columns A and B, switch to:

data want;

update have (obs=0) have;

by a b;

run;

In any case, the data need to be in sorted order to be allowed to use the BY statement.

purveshrana — Tue, 05 Sep 2017 13:31:50 GMT

I figured out a way. Thank you.

Reeza — Tue, 05 Sep 2017 17:15:03 GMT

@purveshrana for completion, please post the solution or mark one here as correct.