Hi all, Am fairly new to SAS and am encountering the following problem. Appreciate if someone could shed some light on it! 🙂 I have a dataset which looks like this: SH_NAME refers to the shareholders who own the firm while holding refers to the percentage ownership of the firm. REVENUE, PROFIT, ASSETS & EQUITY figures are that of the firm total. There are 20 other columns with such firm-level variables. For some variable, there is no info on it (e.g. Equity in the example below). FIRM_NAME SH_NAME HOLDING REVENUE PROFIT ASSETS EQUITY A A1 100 10 2 20 10 B B1 17 B B2 17 100 40 50 B B3 17 B B4 17 B B5 17 B B6 17 Is there a way to fill in the missing blanks such that the final result will look like the following table? FIRM_NAME SH_NAME HOLDING REVENUE PROFIT ASSETS EQUITY A A1 100 10 2 20 10 B B1 17 100 40 50 B B2 17 100 40 50 B B3 17 100 40 50 B B4 17 100 40 50 B B5 17 100 40 50 B B6 17 100 40 50 Thanks in advance!
... View more