topic Re: Repeat the value till the number given in SAS Programming

Repeat the value till the number given

Rajeshganta — Wed, 12 Feb 2020 01:06:15 GMT

How to write a program to repeat a value if x=rajesh for 2 timesthen it has to present as rajesh rajesh

Re: Repeat the value till the number given

Patrick — Wed, 12 Feb 2020 01:34:21 GMT

@Rajeshganta wrote:
How to write a program to repeat a value if x=rajesh for 2 timesthen it has to present as rajesh rajesh

data sample;
  have='rajesh';
  want=repeat(trim(have)||' ',1);
  output;
run;

proc print data=sample;
run;

Re: Repeat the value till the number given

Rajeshganta — Wed, 12 Feb 2020 06:00:35 GMT

Thank you for the solution but i am getting as rajesh rajesh but i want as rajesh
Rajesh in different rows can you please suggest me

Re: Repeat the value till the number given

andreas_lds — Wed, 12 Feb 2020 06:13:11 GMT

Without posting any sample data (in usable form) answering question is almost always guesswork. From your initial post i would have answered the very same that @Patrick did. If you want to duplicate observations, you have to use the output-statement.

data want;
  set have;
  if x = 'rajesh' then output;
  output;
run;

Re: Repeat the value till the number given

Rajeshganta — Wed, 12 Feb 2020 11:14:49 GMT

As per my requirement i want name mentioned in nunber of times in different cells as, if i want rajesh as 2 times
Rajesh
Rajesh

Re: Repeat the value till the number given

gamotte — Wed, 12 Feb 2020 12:22:15 GMT

Please give an example of your input dataset and what the output should look like.

Does this answer your question ?

data have;
input name $ times;
cards;
Rajesh 2
Howard 3
;
run;

data want;
set have;
do i=1 to times;
output;
end;

keep name;
run;

Re: Repeat the value till the number given

Rajeshganta — Thu, 13 Feb 2020 00:45:57 GMT

Thank you it solved my requirement

Re: Repeat the value till the number given

andreas_lds — Thu, 13 Feb 2020 06:03:55 GMT

@Rajeshganta wrote:
Thank you it solved my requirement

Then please set the most helpful post as solution.