topic Re: converting mutliple observations to 1 record of distinct data in SAS Programming

converting mutliple observations to 1 record of distinct data

Deepti44 — Sun, 02 Jul 2017 03:24:20 GMT

Hi I have data some thing like below

account	id
94345	42
94345	26
94345	18
94345	34
94345	42
94345	18

and i want something like this with distinct data in the id field after concatenating,Can any one help me with this !

account	new id
94345	42,26,18,34

Re: converting mutliple observations to 1 record of distinct data

Shmuel — Sun, 02 Jul 2017 04:49:25 GMT

proc sort data=have out=temp nodupkey;
  by account id;
run;

data want;
  set temp;
   by account;
        length new_id $100;  /* addapt to max length needed */
        retain new_id;
        if first.account then new_id = ' ';
        new_id = catx(',',new_id,id);
        if last.account then output;
run;

Re: converting mutliple observations to 1 record of distinct data

Jagadishkatam — Sun, 02 Jul 2017 06:36:17 GMT

Alternatively

proc sort data=have out=temp nodupkey;
  by account id;
run;

proc transpose data=have out=trans;
by account;
var id;
run;

data want;
set trans;
new_id=catx(',',of col:);
drop col: _name_;
run;