topic Re: condensation of data fragmented across variables into one row in SAS Programming

condensation of data fragmented across variables into one row

tellmeaboutityo — Fri, 09 Feb 2018 19:00:18 GMT

Sample problem:

ID----------var1----------var2

123 50

123 Ace .

I would like one row of complete data for each unique ID.

I could make a table for each of the variables and join them back, but I'm thinking there has to be an easier way?

Re: condensation of data fragmented across variables into one row

Reeza — Fri, 09 Feb 2018 19:10:08 GMT

data want;
update have(obs=0) have;
by ID;
run;

You can use the update trick, as above.

@tellmeaboutityo wrote:

Sample problem:

ID----------var1----------var2

123                              50

123          Ace .

I would like one row of complete data for each unique ID.

I could make a table for each of the variables and join them back, but I'm thinking there has to be an easier way?

Re: condensation of data fragmented across variables into one row

tellmeaboutityo — Fri, 09 Feb 2018 19:16:02 GMT

Thanks Reeza, you're the best!