topic Re: generate all values between min & max in New SAS User

generate all values between min & max

LFern — Thu, 19 Aug 2021 15:59:25 GMT

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?

Re: generate all values between min & max

ballardw — Thu, 19 Aug 2021 16:08:27 GMT

@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.

Re: generate all values between min & max

LFern — Thu, 19 Aug 2021 16:26:01 GMT

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

Re: generate all values between min & max

ballardw — Thu, 19 Aug 2021 16:43:21 GMT

@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.