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...
How about:
data want;
set have;
output;
output;
output;
output;
fname=' ';
output;
run;
Do loops?
data want (drop=i); set have; do i=1 to 5; output; end; run;
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;
Is there some logic that the fifth version does not have the fname? is it always to create exactly 5 records?
no suppose you are working in comany and client want output as i shown above
How about:
data want;
set have;
output;
output;
output;
output;
fname=' ';
output;
run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.