topic Re: Merge / Append two differnt columns into one column in SAS Programming

Merge / Append two differnt columns into one column

JUN_Sands — Tue, 19 May 2015 16:23:00 GMT

I have two columns listed below..

Header 1
2
3
4
5
6

Header 1
1
2
5

And I want to create something like this below..

Header 1
1
2
3
4
5
6

Can I do this in SAS data step?

Re: Merge / Append two differnt columns into one column

ballardw — Tue, 19 May 2015 16:42:37 GMT

If the two sets are sorted by the Header variable:

data want;

merge dataset1 dataset2;

by Header1;

run;

If you are combining sets with more variables with the same name then the order the datasets appear on the Merge statement become an issue as will if the BY variable has repeated values in both datasets.

Re: Merge / Append two differnt columns into one column

slchen — Tue, 19 May 2015 16:45:19 GMT

You could use merge or update statement

Re: Merge / Append two differnt columns into one column

JUN_Sands — Tue, 19 May 2015 17:01:01 GMT

I should have mentioned that two columns have different labels. Do I need to change them to same column name before merge them?

Re: Merge / Append two differnt columns into one column

Steelers_In_DC — Tue, 19 May 2015 17:01:47 GMT

Union will eliminate the duplicates and you can sort in the same step:

data have1;

infile cards dsd dlm=',';

input header;

cards;

;

run;

data have2;

infile cards dsd dlm=',';

input header;

cards;

;

run;

proc sql;

create table want as

select header from have1

union

select header from have2

order by header;

Re: Merge / Append two differnt columns into one column

Steelers_In_DC — Tue, 19 May 2015 17:15:47 GMT

If I was doing this using datastep I would do the following:

data want;

set have1 have2;

run;

proc sort data=want nodup;by header;

Re: Merge / Append two differnt columns into one column

Steelers_In_DC — Tue, 19 May 2015 17:18:18 GMT

also:

data want;

update have1 have2;

by header;

run;

Update can get a little trickier. You might want to read up on that to get a better understanding if you use it.

Re: Merge / Append two differnt columns into one column

Steelers_In_DC — Tue, 19 May 2015 17:28:43 GMT

You will have to rename, using either way will look like this:

data want;

update have1 have2(rename=(header_two=header));

by header;

run;

proc sql;

create table want as

select header from have1

union

select header_two as header from have2

order by header;

Re: Merge / Append two differnt columns into one column

ballardw — Tue, 19 May 2015 17:31:44 GMT

If you have any doubt add a label statement to the code. By default variable characteristics such as Label or Format will be the one associated with the first listed data set for those items common to more than one set.