DATA Step, Macro, Functions and more

Inserting sequential similar records

Accepted Solution Solved
Reply
Valued Guide
Posts: 620
Accepted Solution

Inserting sequential similar records

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.


Accepted Solutions
Solution
‎10-02-2017 09:51 AM
Super User
Super User
Posts: 9,866

Re: Inserting sequential similar records

Posted in reply to DavidPhillips2

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;

View solution in original post


All Replies
Solution
‎10-02-2017 09:51 AM
Super User
Super User
Posts: 9,866

Re: Inserting sequential similar records

Posted in reply to DavidPhillips2

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;
Valued Guide
Posts: 620

Re: Inserting sequential similar records

Thanks RW9, this method is very efficient.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 117 views
  • 0 likes
  • 2 in conversation