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

SAS Dataflux Data Management Studio

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

SAS Dataflux Data Management Studio

Hello All,

I have 2 variables in the same data set. Lets say one variable is Name and other is Father's name. After Parsing of name variable we got 2 different fields First name and last name . Now few first names parsed under last name. I had done parsing for father's name. Now I want to concatenate the First name with the last name of father's name. Here I will have 2 condition to concatenate . If First name is null then last name gets concatenate with Father's last name else first name gets concatenate with Father's last name.  Now I want to use concatenate function in expression node. I am not getting that option. Can anyone please help me to find this concatenate function in DQ.


Accepted Solutions
Solution
‎11-06-2017 02:13 AM
SAS Super FREQ
Posts: 99

Re: SAS Dataflux Data Management Studio

Posted in reply to india2016

In the expression node you can just do something like this where FirstName and LastName are existing columns and NewNameCol is a new column to hold your result:

 

string NewNameCol

NewNameCol = FirstName & " " & LastName

 

You can of course wrap some logic around that to combine the names in the way you describe.

 

This expression language guide has a lot of good tips.

 

Ron

View solution in original post


All Replies
Solution
‎11-06-2017 02:13 AM
SAS Super FREQ
Posts: 99

Re: SAS Dataflux Data Management Studio

Posted in reply to india2016

In the expression node you can just do something like this where FirstName and LastName are existing columns and NewNameCol is a new column to hold your result:

 

string NewNameCol

NewNameCol = FirstName & " " & LastName

 

You can of course wrap some logic around that to combine the names in the way you describe.

 

This expression language guide has a lot of good tips.

 

Ron

Contributor
Posts: 67

Re: SAS Dataflux Data Management Studio

Posted in reply to RonAgresta

Thanks Ron

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 386 views
  • 1 like
  • 2 in conversation