topic Re: finding the range in SAS Programming

finding the range

shubham1 — Mon, 17 Sep 2018 06:50:25 GMT

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

Re: finding the range

FredrikE — Mon, 17 Sep 2018 07:35:27 GMT

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

Re: finding the range

PeterClemmensen — Mon, 17 Sep 2018 07:50:24 GMT

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;