topic Re: Help!! SAS Enterprise advanced expression nested if-then statement in SAS Programming

Help!! SAS Enterprise advanced expression nested if-then statement

maliksmom2000 — Fri, 07 Feb 2020 19:26:20 GMT

Please help -

I am trying to have an end result of one number from 4 columns. If column 1 is not blank, then show column 1, if it is blank, show column 2, if column 2 blank show column 3, if column 3 blank use column 4 and if column 4 is blank, leave blank. I used the following expression but I am clearly doing something wrong. Any help would be appreciated.

ifn(t1.'Material Group'n not missing,t1.'Material Group'n, ifn(t1.'Material Group #'n not missing, t1.'Material Group #'n), ifn(t1.'Matl Grp'n not missing, t1.'Matl Grp'n, ifn(t1.'Material Group #1'n not missing, t1.'Material Group #1'n, "")))

Re: Help!! SAS Enterprise advanced expression nested if-then statement

Krueger — Fri, 07 Feb 2020 20:21:22 GMT

If you provide some example data and the log it would be helpful in troubleshooting what your issue is.

Below I've provided an example of what I assume you are trying to do. You can try to make necessary corrections on your side from there.

data have;
	input a b c d;
	datalines;
	1 . . .
	. 3 . .
	. . 4 .
	. . . 2
	;
run;

data want;
	set have;
	test = ifn(not missing(a), a, ifn(not missing(b), b, ifn(not missing(c), c, ifn(not missing(d), d,0))));
run;

Re: Help!! SAS Enterprise advanced expression nested if-then statement

tomrvincent — Fri, 07 Feb 2020 20:23:29 GMT

use coalescec.