How do I generate repeated texts down an existing column? Example inside

[Hello_there]

Data have;
infile datalines dsd dlm=",";
  input name $;
datalines;
Programming,
,
,
Programming,
,
,
Programming,
,
,
;
run;

Hi, How would I get it so the output looks like:

Ex:

1. Programming

2. Is 

3. Cool

4. Programming

2. Is

3. Cool

...

Thanks

[CarmineVerrell]

hhmmm... is this what you are looking for?

Data have;
length name $15;
do j=1 to 1000;
do i=1 to 3;
if i=1 then do; name="Programming"; output; end;
if i=2 then do; name="Is"; output;end;
if i=3 then do; name="Cool"; output;end;
end;
end;

run;

[Hello_there]

Thanks this works well.

[PeterClemmensen]

I don't understand this. If that's your logic, then the word 'is' will be in the 2'nd row. And in the 5'th row. Which is not even?

[Hello_there]

My mistake, but hopefully I made it understandable when I said I was looking for an output that looked like

OBS name

1 Programming

2 Is

3 Cool

4 Programming

5 is

6 Cool

....

Sorry for the mix up

[PeterClemmensen · Accepted solution]

No worries. See if you can use this as a template

Data have;
infile datalines dsd dlm=",";
  input name :$20.;
datalines;
Programming
,
,
Programming
,
,
Programming
,
,
;
run;

data want;
   set have;
   if mod(_N_, 3) = 2 then name = 'Is';
   if mod(_N_, 3) = 0 then name = 'Cool';
run;

[Hello_there]

Thanks! This works well!

[PeterClemmensen]

Anytime 🙂