Base SAS Scenario

[Sharad_Pujari]

i have dataset like 

fname lname

john    kilber

and i want output like this 

fname lname

john    kilber

john    kilber

john    kilber

john    kilber

           kilber

how to do this please help me out... 

[RW9]

Do loops?

data want (drop=i);
  set have;
  do i=1 to 5;
    output;
  end;
run;

[Sharad_Pujari]

yeah it will work but it will show both fname and lname record at same no of observation but i want fname 4 times and lname 5 times

[RW9]

Really not the most difficuly update:

data want (drop=i);
  set have;
  do i=1 to 5;
    if i=5 then fname="";
    output;
  end;
run;

[Sharad_Pujari]

thanks

[ballardw]

Is there some logic that the fifth version does not have the fname? is it always to create exactly 5 records?

[Sharad_Pujari]

no suppose you are working in comany and client want output as i shown above

[Astounding · Accepted solution]

How about:

data want;

set have;

output;

output;

output;

output;

fname=' ';

output;

run;