Desktop productivity for business analysts and programmers

Creating new character variable based on two existing variables

Reply
Contributor
Posts: 34

Creating new character variable based on two existing variables

Folks,

 

I wonder could I get some help on the following. I have two existing character variables which are both ids. One is a product of method a while the other is a product of method b. 

 

I would like to create a third variable which takes the accurate matches from both. A simple table illustrates my point.

 

Also where we have a contrasting match this  output is placed in a second variable. 

 

ID1ID2Final idSecond Id
xxxx5b5b-
6ixxxx6i-
8c5j8c5j
9gxxxx9g-
10b10b10b-

 

 

Any help would be great! 

Grand Advisor
Posts: 17,356

Re: Creating new character variable based on two existing variables

You have the 'xxx' in your dataset as indicated?

Contributor
Posts: 34

Re: Creating new character variable based on two existing variables

[ Edited ]

Hi Reeza,

Yes all failed matches have a 'xxxx' inserted.

Grand Advisor
Posts: 17,356

Re: Creating new character variable based on two existing variables

[ Edited ]

Look at the IFC function. 

 

Or in Query builder, created a new column. You can use a CASE statement in your computed column. 

Respected Advisor
Posts: 4,976

Re: Creating new character variable based on two existing variables

It sounds like some simple logic would do.

 

if ID1=ID2 then Final_id = ID1;

else if ID1='xxxx' then Final_id = ID2;

else if ID2 = 'xxxx' then Final_id = ID1;

else do;

   Final_id = ID1;

   Second_id = ID2;

end;

 

Optionally, if you really want to, you could add:

 

if Second_id = ' ' then Second_id = '-';

Ask a Question
Discussion stats
  • 4 replies
  • 111 views
  • 0 likes
  • 3 in conversation