Creating a new Field from 2 Old Fields

[Cyclist]

I Have parsed the field "Street" and as a result I got threea additional fields: "Street Name, House Number, Extension".

However, I already had the fields "Street_NAME" and "HOUSE_NUM".

What I would like to do is to make a third column which will be populated in in a way that first the values from the "Street_NAME" column are taken, and if that value does not exist, the value from the parsed columnd "treet Name" is taken. Same principle should be applied to House Number as well.

How, and with which nodes can I make this?

[Jagadishkatam]

you could try using the coalecsec function.

new1=coalescec(Street_NAME, Street Name);

new2=coalescec(HOUSE_NUM, House Number);

[Cyclist]

which node I need to use and how (I am new to SAS Data Mgmt Studio)