topic Re: Creating a new Field from 2 Old Fields in SAS Data Management

Creating a new Field from 2 Old Fields

Cyclist — Fri, 03 Jun 2016 10:41:24 GMT

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?

Re: Creating a new Field from 2 Old Fields

Jagadishkatam — Fri, 03 Jun 2016 11:44:24 GMT

you could try using the coalecsec function.

new1=coalescec(Street_NAME, Street Name);

new2=coalescec(HOUSE_NUM, House Number);

Re: Creating a new Field from 2 Old Fields

Cyclist — Fri, 03 Jun 2016 12:14:50 GMT

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