topic Re: Repeating numbers in SAS Programming

Repeating numbers

Saba1 — Mon, 15 Jun 2020 19:17:58 GMT

Hi
I want to create a sequence of unique numbers in a column, but each number must repeat 5 times (i.e. same number in 5 rows). For example number 1 in first five rows, then number 2 must again repeat five times and so on.
Please help. Thanks

Re: Repeating numbers

r_behata — Mon, 15 Jun 2020 18:57:57 GMT

Is this what you are after ?

data want;
	do i=1 to 5;
		num=input(compress(repeat(i,5)),8.);
		putlog num=;
		output;
	end;

	drop i;
run;

Log :

num=111111
num=222222
num=333333
num=444444
num=555555

Re: Repeating numbers

PGStats — Mon, 15 Jun 2020 19:02:43 GMT

Assuming you want to add this column to existing data:

data want;
set have;
id  = ceil(_n_ / 5);
run;

Re: Repeating numbers

Saba1 — Mon, 15 Jun 2020 19:13:54 GMT

@r_behata: thanks. No, i want "1" to be in first five rows, then "2" in next 5 rows, and so on.

Re: Repeating numbers

Astounding — Mon, 15 Jun 2020 19:17:20 GMT

Perhaps this is what you are looking for:

data want;
do num=1 to 5;
   output; output; output; output; output;
end;
run;

Re: Repeating numbers

r_behata — Mon, 15 Jun 2020 19:18:27 GMT

data want;
	do i=1 to 5;
		j=1;
		do while(j < 6);
			num=i;
			output;
			j+1;
		end;
	end;

	drop i j;
run;

Re: Repeating numbers

yabwon — Mon, 15 Jun 2020 19:20:06 GMT

data want;
  do number = 1 to 42;
    do _N_ = 1 to 5;
      output;
    end;
  end;
run;

Re: Repeating numbers

smantha — Mon, 15 Jun 2020 20:46:05 GMT

data new;
set old;
string=repeat(strip(put(int(_n_/5) +1,$32.)),5);
if mod(_n_,5) ==0 then string=repeat(strip(put(int(_n_/5) ,$32.)),5);
run;

Is this what you want?

Re: Repeating numbers

ballardw — Mon, 15 Jun 2020 22:03:28 GMT

In pedantic mode I would say that you have conflicting requirements: "unique number" and "five times". Unique means one value.

And how many times is "so on"? How do we know when to quit? Are you attempting to add this value to an existing data set? Build a data set that only has this sequence?