topic Re: Join Variables and Observations in SAS Data Management

Join Variables and Observations

eyespike1 — Mon, 26 Jan 2015 21:04:42 GMT

Hi, I hope I am posting in the correct area. I would like to combine Gender1 and Gender5 with Gender5 being the winner if there is a value in both. Also for Education1 and Education5.

Is this possible in EG or EM?

I would do this in excel, but there are about 20 columns i would like to combine.

Any help would be appreciated.

Thanks!

Seth

id	Gender1	Gender5	Education1	Education5
1		F	1
2	F			2
3	F		3
4	F		3
5	F		1
6		M	1
7	F
8	F		1
9	F		1
10	F		2
11	F		1
12	F		1
13	F	M	3	3
14	F		1
15	F		1
16	F		1

Re: Join Variables and Observations

LinusH — Mon, 26 Jan 2015 21:16:16 GMT

So the variables are in the same data set?

Use the coalesce function. In EG you can use the query builder and there you need to define a calculated column.

Re: Join Variables and Observations

eyespike1 — Mon, 26 Jan 2015 21:24:46 GMT

Yes, the variables are in the same data set.

Re: Join Variables and Observations

Reeza — Mon, 26 Jan 2015 21:45:28 GMT

What do you mean by combine? Can more than one variable have a value at the same time, i.e. Gender1=F Gender5=M?

Re: Join Variables and Observations

eyespike1 — Mon, 26 Jan 2015 22:01:15 GMT

For each ID there will only be one Gender value and one Education value like the combined columns below.

id	Gender Combined	Gender1	Gender5	Education Combined	Education1	Education5
1	F		F	1	1
2	F	F		2		2
3	F	F		3	3
4	F	F		3	3
5	F	F		1	1
6	M		M	1	1
7	F	F
8	F	F		1	1
9	F	F		1	1
10	F	F		2	2
11	F	F		1	1
12	F	F		1	1
13	M	F	M	3	3	3
14	F	F		1	1
15	F	F		1	1
16	F	F		1	1

Re: Join Variables and Observations

Reeza — Mon, 26 Jan 2015 22:29:42 GMT

The coalesceC function is what you're looking for.

In EG can use a computed column, not sure about EM but could always write a code node.

gender_combined=coalesceC(of gender1-gender5);