topic Create a new column based if one column matches another column in SAS Programming

Create a new column based if one column matches another column

Newbie_23 — Thu, 25 Jan 2024 19:22:54 GMT

Hello, I am using SAS 9.4

and I am trying to compare two columns of data and make a new column that helps me identify if any data in column A is not in column B, (identified as "Y" in the new column)

Set: Have

A B

Bo bo

Po xy

Ro ro

set: want

A B match (A = B?)

Bo Bo 1

Po xy N

Ro ro Y

Create a new column based if one column matches another column

Newbie_23 — Thu, 25 Jan 2024 19:20:18 GMT

Hello, I am using SAS 9.4

and I am trying to compare two columns of data and make a new column that helps me identify if any data in column A is not in column B, (identified as "Y" in the new column)

Set: Have

A B

Bo bo

Po xy

Ro ro

set: want

A B match (A = B?)

Bo Bo 1

Po xy N

Ro ro Y

Re: Create a new column based if one column matches another column

Newbie_23 — Thu, 25 Jan 2024 19:34:10 GMT

Hello, I am using SAS 9.4

and I am trying to compare two columns of data and make a new column that helps me identify if any data in column A is not in column B, (identified as "Y" in the new column)

Set: Have

A B

Bo bo

Po xy

Ro ro

set: want

A B match (A = B?)

Bo Bo Y

Po xy N

Ro ro Y

Re: Create a new column based if one column matches another column

Kurt_Bremser — Thu, 25 Jan 2024 19:55:33 GMT

match = ifc(upcase(a) = upcase(b),"Y","N");

Re: Create a new column based if one column matches another column

Peter_C — Thu, 25 Jan 2024 23:00:03 GMT

I Assume you are looking for cases where A contains any text character that is not in B.
Have a look at the COMPRESS() function,
Especially the second parameter.