Display row data in a line

[Abraham]

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

[RW9 · Accepted solution]

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;