topic Re: Merge 2 variables in SAS Programming

Merge 2 variables

user24 — Fri, 07 Apr 2017 17:22:16 GMT

How can i merge 2 variable if the one ofthem is null

id work number

5 0

8 1 1-2

9 2 2-5

i want to change as if the number is null merge with 'work'

id work number

5 0 0

8 1 1-2

9 2 2-5

Re: Merge 2 variables

collinelliot — Fri, 07 Apr 2017 17:33:21 GMT

Do you have any code that you're currently trying? It's not clear to me if you want to merge on all three variables or just the first two and you want to figure out how to deal with third.

Re: Merge 2 variables

user24 — Fri, 07 Apr 2017 17:37:07 GMT

if the 'number' is null and 'work' has variable, add that variable to the 'number' by 'id'. Is that clear?

Re: Merge 2 variables

collinelliot — Fri, 07 Apr 2017 17:46:06 GMT

Not entirely, but I can be a bit daft. But from what I understand, you could try:

if not missing(work) then number = coalescec(number, '0');

Re: Merge 2 variables

collinelliot — Fri, 07 Apr 2017 17:48:13 GMT

Or if you mean that you want to populate 'number' with 'work,' you could do:

number = coalescec(number, work);

I'm not sure about what the variable types are, though.

Re: Merge 2 variables

user24 — Fri, 07 Apr 2017 17:55:02 GMT

I have chracter variable. Also you can think like its left join . i only want to take if the work has variable and number doesn;t have variable.

id work number

11 2 2

13 3 3

15 1 1-2

16 2 2-3

So i have the table without red variables. I want the table with red variables

Re: Merge 2 variables

collinelliot — Fri, 07 Apr 2017 18:00:50 GMT

Like this?

data have;
infile datalines dsd;
input id work $ number $;
datalines;
11, 2,       
12, ,   
13, 3,
15, 1, 1-2
16, 2, 2-3 
;

data want;
    set have;
    number = coalescec(number, work);
run;

Re: Merge 2 variables

Astounding — Fri, 07 Apr 2017 19:15:15 GMT

Isn't this simply:

if number = ' ' then number = work;