Display row data in a line

Abraham — Mon, 03 Aug 2015 14:02:16 GMT

Hello,

In my dataset, I want to display my output like below. How to proceed

data emp;

input deptno $ doj : date9.;

format doj date9.;

cards;

10 23jan2012

10 28mar2013

10 31mar2013

20 10apr2012

30 11apr2014

30 18apr2014

30 24jun2014

30 31aug2014

;

run;

Output

10	23JAN2012,28MAR2013,31MAR2013

20 10APR2012

30 11APR2014,18APR2014,24JUN2014,31AUG2014

Re: Display row data in a line

RW9 — Mon, 03 Aug 2015 14:05:59 GMT

Hi,

data want;

set emp;

length dts $200;

retain dts;

by deptno;

if first.deptno then dts=put(doj,date9.);

else dts=catx(',',dts,put(doj,date9.));

if last.deptno then output;

run;