SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Creating a new Field from 2 Old Fields

Reply
Contributor
Posts: 23

Creating a new Field from 2 Old Fields

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?

Trusted Advisor
Posts: 1,131

Re: Creating a new Field from 2 Old Fields

you could try using the coalecsec function.

 

new1=coalescec(Street_NAME, Street Name);

new2=coalescec(HOUSE_NUM, House Number);

Thanks,
Jag
Contributor
Posts: 23

Re: Creating a new Field from 2 Old Fields

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

Ask a Question
Discussion stats
  • 2 replies
  • 225 views
  • 0 likes
  • 2 in conversation