Help using Base SAS procedures

Display row data in a line

Accepted Solution Solved
Reply
Contributor
Posts: 63
Accepted Solution

Display row data in a line

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


Accepted Solutions
Solution
‎08-03-2015 10:06 AM
Super User
Super User
Posts: 7,942

Re: Display row data in a line

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;

View solution in original post


All Replies
Solution
‎08-03-2015 10:06 AM
Super User
Super User
Posts: 7,942

Re: Display row data in a line

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 218 views
  • 0 likes
  • 2 in conversation