change data format from multiple rows per id to one row per id

fengyuwuzu — Tue, 27 Sep 2016 13:48:44 GMT

I have data like below :

And I want to have data like :

One way is to output 4 data for m1, m2, m3 and m4 and then merge.

I wonder if there is a simpler way to do it? Thanks

Re: change data format from multiple rows per id to one row per id

Reeza — Tue, 27 Sep 2016 13:55:14 GMT

Use SQL and take max of each column per id

use update trick

data want;

Update have (obs=0) have;

by id visit;

run;