topic Re: How to Copy One record to Next record in SAS Programming

How to Copy One record to Next record

vThanu — Sat, 23 Mar 2019 06:10:52 GMT

I have only 1 record in my dataset and I want to copy that record and get the same in the second record.

for example

data have;

x="Micro soft"

run;

expected output

Micro soft

Micro Soft

Thanks in advance

Re: How to Copy One record to Next record

Astounding — Sat, 23 Mar 2019 06:14:24 GMT

Try:

data want;
Set have;
output;
output;
run;

Re: How to Copy One record to Next record

PeterClemmensen — Sat, 23 Mar 2019 06:14:27 GMT

I'm not sure if this meets your actual needs, but you can control how many times an observation is written to your data set with the Output Statement like this.

data have;
x="Micro soft";
output;
output;
run;

proc print data=have;
run;

Re: How to Copy One record to Next record

vThanu — Sat, 23 Mar 2019 06:33:51 GMT

apart from this do we have any other options....
like do look
do i = 1 to 2 (what ever the no we want)...

Re: How to Copy One record to Next record

PeterClemmensen — Sat, 23 Mar 2019 06:35:23 GMT

Yes, this gives you the same

data have;
x="Micro soft";
do i=1 to 2;
   output;
end;
run;

proc print data=have;
run;

Re: How to Copy One record to Next record

vThanu — Sat, 23 Mar 2019 07:38:21 GMT

Thank you.. 🙂