topic Re: Need to create obs based on two columns start and end in SAS Programming

Need to create obs based on two columns start and end

Fettah — Thu, 25 Feb 2021 02:03:14 GMT

Can you please advice how I might create observations containing a range of values, where the range is specified by two columns: start, and end.

Essentially, how do I convert this:

data have;
input start end;
datalines;
100 103
301 305
336 338
;

to this:

data want;
input start end num;
datalines;
100 120 100
100 120 101
100 120 102
301 305 301
301 305 302
301 305 303
301 305 304
301 305 305
336 338 336
336 338 337
336 338 338 
;

Re: Need to create obs based on two columns start and end

japelin — Thu, 25 Feb 2021 02:35:39 GMT


data want;
  set have;
  do num=start to end;
    output;
  end;
run;

try this code.

Re: Need to create obs based on two columns start and end

ballardw — Thu, 25 Feb 2021 02:39:38 GMT

So, how does "end" get transformed to 120, 305 and 338 in that output?

And are you sure that you don't want a

100 120 103

in the output as well?

Without changing the "end" which you did not provide any logic for this is the basic approach

data want;
   set have;
   do num=start to end;
      output;
   end;
run;

The explicit OUTPUT statement means that data is written into the output data set each time it executes, once for each value in the Do loop.

Re: Need to create obs based on two columns start and end

Fettah — Thu, 25 Feb 2021 03:00:21 GMT

Woops. that was a typo. Thanks for pointing it out.

Re: Need to create obs based on two columns start and end

Fettah — Thu, 25 Feb 2021 03:02:07 GMT

Works like a charm, thank you!