topic Filling the empty cell while merging in SAS Programming

Filling the empty cell while merging

abdulla — Sat, 09 Feb 2019 18:13:23 GMT

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.

Re: Filling the empty cell while merging

VDD — Sat, 09 Feb 2019 17:17:50 GMT

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.

Re: Filling the empty cell while merging

andreas_lds — Sat, 09 Feb 2019 17:48:22 GMT

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.

Re: Filling the empty cell while merging

abdulla — Sat, 09 Feb 2019 18:14:35 GMT

I changed it

Re: Filling the empty cell while merging

PGStats — Sat, 09 Feb 2019 23:39:43 GMT

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;

Re: Filling the empty cell while merging

Reeza — Sun, 10 Feb 2019 00:58:01 GMT

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

@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.