12-19-2016 04:26 AM
I have data where todays closing becomes next days opening after calculations in Base SAS Code I have written and I have data from Jan2016 to Jul2016 so what is happening here is when I run one time data for 1st jan matches when I run second time data for 2nd jan matches and so on but how to cut down this repeting process short so that I can get all the matching values in one go.
12-19-2016 04:32 AM
12-19-2016 07:18 AM
We're all guessing, but this might be what you want: compute today's opening.
If so, the opening for the first day can't be computed. But here's one approach to get as much as possible from the data:
proc sort data=have;
by company date;
opening = lag(closing);
if first.company then opening=.;