finding the range

[shubham1]

Hello

I have a dataset 

data have;
input x $ Y $;
datalines
08 c1
08 c2
09 c1
09 c2
09 c3
10 c1
10 c2
10 c3
10 c4
;
run;

I want my output to be 

08c1-08c2
09c1-09c3
10c1-10c4

[FredrikE]

Not the most beautiful, but works in this case...:)

proc sql; 
 create table want as
 select  cats (x, min(y),'-',x,max(y)) as mix
 from have
 group by x
 ;
quit;

//Fredrik

[PeterClemmensen · Accepted solution]

data have;
input x $ Y $;
datalines;
08 c1
08 c2
09 c1
09 c2
09 c3
10 c1
10 c2
10 c3
10 c4
;
run;

data want(keep=NewVar);
   set have;
   by x;
   if first.x then NewVar=cats(x, Y);
   if last.x then do;
      NewVar=catx('-', NewVar, cats(x, Y));
      output;
   end;
   retain NewVar;
run;