Please show a sample of the data for a couple of companies, in a sas data step. Nobody can make a programming recommendation without knowing the data layout and some data values.
And then show what you would like the output to look like for your example input data.
... View more
