topic Re: Adding extra rows in SAS Programming

Adding extra rows

vikram2000 — Sat, 18 May 2019 11:38:13 GMT

how to add extra rows to the existing data set in sas university edition?

ex- i have only 5 rows , how can i automatcally increase rows with empty values

how to make the 5 rows as 500 rows

Re: SAS Univ Edition

Jagadishkatam — Sat, 18 May 2019 11:36:24 GMT

please try this example, hope it helps

data have;
set sashelp.class end=eof;
output;
if eof then do i = 1 to 500;
call missing (name,sex,age,height,weight);
output;
end;
run;

Re: SAS Univ Edition

PeterClemmensen — Sat, 18 May 2019 11:36:51 GMT

Hi and welcome to the SAS Communities 🙂

You can do something like this

data have;
input id $ var;
datalines;
1 1
2 2
3 3
4 4
5 5
;

data want(drop=i);
   set have end=lr;
   output;
   if lr then do;
   call missing (of _numeric_);
   call missing (of _character_);
      do i=1 to 495;
         output;
      end;
   end;
run;

Re: Adding extra rows

Kurt_Bremser — Sat, 18 May 2019 11:38:37 GMT

One idea: do a loop that counts to 100 for every observation read.

Note that just adding "empty" records only wastes space, but achieves nothing else that has any information value.

Re: Adding extra rows

Kurt_Bremser — Sat, 18 May 2019 11:39:33 GMT

PS I corrected your meaningless subject line.