topic How do I generate repeated texts down an existing column? Example inside in SAS Programming

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

Hello_there — Fri, 11 Feb 2022 18:43:16 GMT

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

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

CarmineVerrell — Fri, 11 Feb 2022 18:34:21 GMT

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;

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

PeterClemmensen — Fri, 11 Feb 2022 18:29:33 GMT

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?

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

Hello_there — Fri, 11 Feb 2022 18:42:38 GMT

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

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

PeterClemmensen — Fri, 11 Feb 2022 18:46:45 GMT

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;

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

Hello_there — Fri, 11 Feb 2022 19:19:00 GMT

Thanks this works well.

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

Hello_there — Fri, 11 Feb 2022 19:23:38 GMT

Thanks! This works well!

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

PeterClemmensen — Fri, 11 Feb 2022 20:29:26 GMT

Anytime 🙂