data want (keep=name contact1 contact2); set have; by name; retain i contact1-contact9; /* adapt to max number of contacts expected */ drop i contact; array cn {*} contact1-contact9 ; if first.name then i=1; cn(i) = contact; i+1; if last.name then output; run;   Name Contact1 Contact2 a 1234678 991122488 b 8795643210 77889912 c 4085794 77889912 d 9112456781 77889912   The resulted output showing repeated values for record C and record D of record B values. Ideally it should be . (period) or blank...   ... View more

Hello, Plz can any one help me how to read mutliple records into single record on conditionally   data have; input name$ contact 10.; datalines; a 1234678 a 9911224488 b 8795643210 c 04085794 d 9112456781 b 77889912 ;   and looking for the below result. (if the name appears twice and have muliple records should be write in single record in the result like below)     Name$  landline             Mobile a           1234678            9911224488 b           77889912           8795643210 c           04085794                             . d                           .         9112456781       ... View more