Concatenate data in multiple rows

Sasforme — Mon, 24 Sep 2018 07:34:44 GMT

I have a dataset that have one id and multiple block and street names.I need to place together all the blocks and street names of an id together by concatenating separated by a comma.
The dataset looks like this.

ID block street name
Ttk1 104A John's street
104B John's street
Ttk2 614 Mary street
615 Mary street
616 Mary street
617 Mary street
618 Mary street
Ttk3 415 Brooklyn street
Ttk4 202 Nashville street
203 Nashville street

The final dataset should look like this.
Ttk1 104A John's street,104B
John's street
Ttk2 614 Mary street,615
Mary street,616 Mary street,
617 Mary street,618 Mary street
Ttk3 415 Brooklyn street
Ttk4 202 Nashville street,203
Nashville street

I have tried CATX but couldn't get these results. Any sugestions on how this can be achieved?

Re: Concatenate data in multiple rows

RW9 — Mon, 24 Sep 2018 07:48:32 GMT

Please post test data in the form of a datastep in future, as such this is untested:

data want;
  set have;
  length full $2000;
  retain full;
  by id;
  full=ifc(first.id,full,catx(",",full,block_street_name);
run;

topic Re: Concatenate data in multiple rows in SAS Data Management

Concatenate data in multiple rows

Re: Concatenate data in multiple rows