Filling the empty cell while merging

[abdulla]

Hi,

What I want is to fill the highlighted cell while merging with respective number in the cell. For example for the 1st row market_return will be 0.2487176983 and for the 1st 12 row adjusted_return will be 0.7965715684.  

[VDD]

https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting

please post you haves and want into a form that others could reply to please.

[andreas_lds]

Sorry, but I won't open any office documents poster in the internet. If you want help, post explain your problem including usable test-data and what you expect as result using {i} window.

[abdulla]

I changed it

[PGStats · Accepted solution]

So, all you need is to merge with newA instead of A

proc sql;
create table newA as
select 
    permno, 
    max(adjusted_return) as adjusted_return,
    max(market_return) as market_return
from A
group by permno;
quit;

[Reeza]

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

---

@abdulla wrote:

Hi,

What I want is to fill the highlighted cell while merging with respective number in the cell. For example for the 1st row market_return will be 0.2487176983 and for the 1st 12 row adjusted_return will be 0.7965715684.  

---