topic Re: SAS Dataflux Data Management Studio in SAS Data Management

SAS Dataflux Data Management Studio

india2016 — Fri, 03 Nov 2017 05:22:11 GMT

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.

Re: SAS Dataflux Data Management Studio

RonAgresta — Sun, 05 Nov 2017 22:56:09 GMT

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

Re: SAS Dataflux Data Management Studio

india2016 — Mon, 06 Nov 2017 07:14:21 GMT

Thanks Ron