topic Re: Inserting sequential similar records in SAS Programming

Inserting sequential similar records

DavidPhillips2 — Mon, 02 Oct 2017 13:20:55 GMT

I’m trying to create a table that has future years. For example with sashelp.orsales2, I’d like to insert 10 rows per with the same values as the orginal record but with a new column yearFuture that increments by 1 per year e.g. 1999, 2000, 2001… I can see one way to do this as creating a new table with the year column and joining it back to the current table. I do not know the sas syntax for creating the loop for the years in a SAS program.

Re: Inserting sequential similar records

RW9 — Mon, 02 Oct 2017 13:50:52 GMT

Can't see any data (don't have SAS available at mo), so maybe something like:

data have;
  year=2010; var1="A"; var2=12; output;
  year=2011; var1="B"; var2=45; output;
run;

data want (drop=i);
  set have;
  do i=0 to 9;
    year=year+i;
    output;
  end;
run;

Re: Inserting sequential similar records

DavidPhillips2 — Mon, 02 Oct 2017 13:52:05 GMT

Thanks RW9, this method is very efficient.