topic Re: Table creation by data in SAS Programming

Table creation by data

Srigyan — Fri, 26 Oct 2018 13:02:34 GMT

I have a table

Product_ID	starting Date	price
ID1	01-Jan-18	7
ID1	05-Jan-18	89
ID1	07-Jan-18	6

I want to write the code to generate below data point

Product_ID	starting Date	price
ID1	01-Jan-18	7
ID1	02-Jan-18	7
ID1	03-Jan-18	7
ID1	04-Jan-18	7
ID1	05-Jan-18	89
ID1	06-Jan-18	89
ID1	07-Jan-18	6

Re: Table creation by data

RW9 — Fri, 26 Oct 2018 13:19:17 GMT

Post test data in the form of a datastep!

As such not tested:

data want;
  set have;
  by product_id;
  retain lstdt;
  if first.product_id then lstdt=starting_date;
  else do;
    do i=1 to starting_date-lstdt;
      output;
      starting_date=starting_date+i;
    end;
  end;
run;

Re: Table creation by data

Ksharp — Fri, 26 Oct 2018 14:01:32 GMT

data have;
infile cards expandtabs truncover;
input Product_ID $	startingDate : date11. price;
format startingDate date9.;
cards;
ID1	01-Jan-18	7
ID1	05-Jan-18	89
ID1	07-Jan-18	6
;
run;
data want;
 merge have have(keep=Product_ID startingDate
 rename=(Product_ID=_p startingDate=_s) firstobs=2);
output;
if Product_ID=_p then do;
  do i=startingDate+1 to _s-1;
    startingDate=i;output;
  end;
end;
drop i _p _s;
run;