I Have a dataset named Details with the following columns: Date        Ind Stacks Nets Start End 01st May 2020 Y 10 4 9 13 2nd May 2020 Y 5 6     3rd May 2020 Y 4 7     4th May 2020 Y 3 9     5th May 2020 Y 2 5       I want to create the values of Start and End in the following table using previous day values. Start will be Previous day end and End will be start + nets and need to iterate this for all days using proc data step. The table needs to look like this:   Date        Ind Stacks Nets Start End 01st May 2020 Y 10 4 9 13 2nd May 2020 Y 5 6 13 19 3rd May 2020 Y 4 7 26 33 4th May 2020 Y 3 9 33 42 5th May 2020 Y 2 5 42 47   I tried the following code with no success and needs help in determining what I did wrong:   data FinalTable; set Details ; by Date ; retain IND STACK NETS START END ; if first. date then do; IND = IND; STACK = STACKS; NETS = NETS; START = START; END = END; end; if last. date then do; END =START + NETS; output; START=END; end; run; proc print; run; ... View more

I have a dataset named Entry with the following columns Date        Category  Indicator  Total 01Nov-2021  Starting    13 01Nov-2021  Add  TRUE 10 01Nov-2021  Add  TRUE 7 01Nov-2021  Subs  FALSE 6 01Nov-2021  Subs  FALSE 5 02Nov-2021  Add  TRUE 6 02Nov-2021  Add  TRUE 8 02Nov-2021  Subs  FALSE 6 02Nov-2021  Subs  FALSE 2 03Nov-2021  Add  TRUE 7 03Nov-2021  Add  TRUE 2 03Nov-2021  Subs  FALSE 8 03Nov-2021  Subs  FALSE 1   Now, I want to create the following dataset:   Date Starting Add_total Subs_Total Add_true Add_False Subs_True Subs_False Nets_Total Nets_True Nets_False Ending 01stNov2021 13 17 11 10 7 6 5 6 4 2 19 02nd Nov 2021 19 14 8 6 8 6 2 6 0 6 25 03rd Nov 2021 25 9 9 7 2 8 1 0 -1 1 25    Starting - Total of category - Starting for the day  Add_Total - Total of Category Adds Subs_Total - Total of Category Subs  Nets_Total - Adds_Total - Subs_total Nets_True - Adds_true - Subs_true Nets_false - Adds_false - Subs_False Ending - Starting + Nets_Total   Moreover, the ending for the previous day needs to be starting for the next day and so on. Is it possible to do it in one query. I tried    PROC SQL; CREATE TABLE Test AS SELECT Date, sum(case when Category = 'Starting' then Total end) as Starting, sum(case when Category = 'Add' then Total end) as AddTotal, sum(case when Category = 'Subs' then Total end) as SubsTotal, sum(case when Category = 'Add' and Indicator = 'True' then Total end) as Addtrue sum(case when Category = 'Add' and Indicator = 'False' then Total end) as Addfalse sum(case when Category = 'Subs' and Indicator = 'True' then Total end) as Substrue sum(case when Category = 'Subs' and Indicator = 'False' then Total end) as Subsfalse calculated Add_Total - calculated Subs_Total as Nets_Total, calculated Add_true - calculated Subs_true as Nets_True, calculated Add_false - calculated Subs_false as Nets_false, calculated Starting + Nets_Total as Ending FROM Entry ; QUIT;   But need help in sorting out for the Starting and Ending for each day.      ... View more