topic day on day code run in SAS Programming

day on day code run

nishukhawale — Mon, 19 Dec 2016 09:26:03 GMT

Hi,

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.

Thnaks,

Re: day on day code run

Kurt_Bremser — Mon, 19 Dec 2016 09:32:24 GMT

Please supply

- example data (data step)

- the code you already have

- the intended result

Re: day on day code run

Shmuel — Mon, 19 Dec 2016 09:33:16 GMT

Please give a sample example of your data and the output you want.

Re: day on day code run

SBRVamsi — Mon, 19 Dec 2016 10:03:02 GMT

Please provide the dataset for further reference and to drill down on the question

Thanks

Vamsi.

Re: day on day code run

Astounding — Mon, 19 Dec 2016 12:18:14 GMT

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;

run;

data want;

set have;

by company;

opening = lag(closing);

if first.company then opening=.;

run;