Yes, this is trivial and answered in multiple places on here. Posting on a two-year-old thread is not advised.
data want;
update have(obs=0) have;
by ID;
run;
@Saraja wrote:
Let me ask this question on the author's behalf so that we will have some meaningful answered down the line:
We have multiple decors by the ID. There are missing values due the fact that there are multiple records per ID instead on unique values.
ID
age2015
age2016
BP2015
BP2016
Weight2015
Weight2016
1
55
235
178
1
56
201
154
Using ID as a grouping variable how we can merge both records into single one so that there will be no more missing values such as here:
ID
age2015
age2016
BP2015
BP2016
Weight2015
Weight2016
1
55
56
235
201
178
154
Also, there are several hundred such variables, can we run the code without naming the variables explicitly.
Thanks!
Sartaj
... View more