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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.