topic Add Column Based on a logic in New SAS User

Add Column Based on a logic

Kirito1 — Mon, 09 Jan 2023 11:29:35 GMT

I was working on a data where a table has 3 columns in which some of the column values are missing for example:

Now, I want to achieve something like this. Where LC_CODE is not provided we pick from LG_CODE and if LG_CODE is not provided we pick from referral code. And if we don't have any values for any of the columns we just leave it as blank.

So the desired output should be something like this as below

Something LIKE this

Data FIN_EMP_CODE;
set MR7;
FIN_EMP_CODE = ;
if('LC Code'.MR7 NE . then 'LC Code'N = FIN_EMP_CODE);
else if ('LG Code'.MR7 NE . then 'LG Code'N = FIN_EMP_CODE);
else ('Referal Code'N.MR7 NE . then 'Referal Code'N = FIN_EMP_CODE);
run;

Can someone suggest what should I do to achieve this. Please, HELP!!!

Re: Add Column Based on a logic

Kirito1 — Mon, 09 Jan 2023 11:34:33 GMT

I am not even sure the pseudo code I wrote is correct or not.

Re: Add Column Based on a logic

Astounding — Mon, 09 Jan 2023 11:38:48 GMT

Take a look at the COALESCE function.

Re: Add Column Based on a logic

Kirito1 — Mon, 09 Jan 2023 11:42:03 GMT

Can you suggest any quick pseudo code for this ...........Although I am reading the function you suggested.

Re: Add Column Based on a logic

PaigeMiller — Mon, 09 Jan 2023 11:45:52 GMT

data want;
    set have;
    ref_code=coalesce(lc_code,lg_code);
run;

Re: Add Column Based on a logic

Kirito1 — Mon, 09 Jan 2023 11:47:20 GMT

yep its working thank you