topic Re: Generate string of integers between two numbers in SAS Programming

Generate string of integers between two numbers

aawve — Wed, 20 Oct 2021 19:22:48 GMT

Hello,

I have data in the following structure:

InitialString	FirstNumber	SecondNumber
14-17	14	17
15-17	15	17
16-17	16	17
14-16	14	16

I'm hoping to create a delimited string that contains the full sequence of numbers between "FirstNumber" and "SecondNumber", inclusively, given that the initial string could contain a wide variety of "FirstNumber" and "SecondNumber" values. See desired outcome below:

InitialString	FirstNumber	SecondNumber	FinalString
14-17	14	17	14; 15; 16; 17
15-17	15	17	15; 16; 17
16-17	16	17	16; 17
14-16	14	16	14; 15; 16

Please let me know how I might accomplish this task automatically. The simpler, the better. Thank you.

Re: Generate string of integers between two numbers

yabwon — Wed, 20 Oct 2021 19:39:39 GMT

try this:

data have;
input InitialString	$ FirstNumber SecondNumber;
cards;
14-17	14	17
15-17	15	17
16-17	16	17
14-16	14	16
;
run;
proc print;
run;

data want;
  set have;

  length FinalString $ 200; /* set accordingly to your data */
  do _N_ = FirstNumber to SecondNumber;
    FinalString = catx("; ",FinalString,_N_);
  end;
run;
proc print;
run;

Bart

Re: Generate string of integers between two numbers

aawve — Wed, 20 Oct 2021 20:43:03 GMT

The solution is simple and worked easily. Thank you.