In the same period 180 units were sold. The first method to calculate the weighted average in SAS is with PROC SQL. The final calculation will provide a weighted average value for every item available for sale.
To determine the weight of each number consider its.
The code is straightforward and easy to remember. Youll need to start by assembling a list of the numbers for. The rest which is 28500- 6840 21660 goes to the ending inventory for the Jan-March period. How to calculate weighted average when the weights dont add up to one 1.