generate all values between min & max

[LFern]

Hello,

I have:

data have;
input country $6. min max ;
datalines;
Canada 495 507
Haiti 10 15
;
run;

I want either of these versions (they're substantively the same but one is long-format and the other is wide-format):

Wide format:

Long format:

Any suggestions?

[ballardw · Accepted solution]

---

@LFern wrote:

Hello,

I have:

data have;
input country $6. min max ;
datalines;
Canada 495 507
Haiti 10 15
;
run;

I want either of these versions (they're substantively the same but one is long-format and the other is wide-format):

Wide format:

Long format:

Any suggestions?

---

data want;
  set have;
  do in_range=min to max;
     output;
  end;
  keep country in_range;
run;

If you want the "wide" version you could use proc transpose but can't see any real advantage to that.

I have to assume you wanted the integer versions. "All values", in a mathematical sense, is an infinite number of values regardless of the range.

[LFern]

oh gosh this is so simple and clean! I was working through loops and arrays for no reason. Thank you so much!

[ballardw]

---

@LFern wrote:

oh gosh this is so simple and clean! I was working through loops and arrays for no reason. Thank you so much!

---

If you were doing that to attempt a wide solution then you see why wide is very frequently not a good idea.