Repeating numbers

[Saba1]

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

[r_behata]

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

[Saba1]

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

[r_behata]

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

	drop i j;
run;

[yabwon]

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

[Astounding]

Perhaps this is what you are looking for:

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

[PGStats · Accepted solution]

Assuming you want to add this column to existing data:

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

[smantha]

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?

[ballardw]

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?