topic Re: Combine Tables Help in SAS Enterprise Guide

Combine Tables Help

Alex_Ji — Thu, 25 Jun 2015 14:51:04 GMT

Hi all,

Sorry in advance if this is a silly question. But how do I combine 2 columns from two different SAS files? I tried query building, but query builder created a SAS file with two seperate columns and I want these two columns combine into one column instead. Am I using the wrong tool or is there another way to join.

Thanks in advance.

Alex

Re: Combine Tables Help

dcruik — Thu, 25 Jun 2015 14:56:35 GMT

I think it would make it easier for us to help you out if you provided some example data in the two data sets you want to combine, and then a brief example of the output you're looking to achieve. Dummy data can be used, just so we understand the structure of the two data sets and the desired output you are wanting. Thanks!

Re: Combine Tables Help

ballardw — Thu, 25 Jun 2015 14:58:04 GMT

Provide some examples of the 2 input data sets and what you want the output to look like. There are several ways to interpret "combine 2 columns" and details will help. Also let us know, if there is possible confusion, if a variable that looks numeric is actually a character variable.

Re: Combine Tables Help

LinusH — Thu, 25 Jun 2015 15:14:53 GMT

If you are using enterprise guide query builder, you need to define a calculated column, where you need to specify an expression how you wish to combine the column values.

Re: Combine Tables Help

Alex_Ji — Thu, 25 Jun 2015 18:32:37 GMT

So, it is actually really simple. I have two SAS data files.

I want to combined then to one that looks like this.

File 1 has a bunch of text, file 2 has a bunch of text. I want them in one column. However, I am currently getting them in two columns when running query builder with outer joint function.

Thanks for your help.

Re: Combine Tables Help

RRM — Thu, 25 Jun 2015 18:45:59 GMT

You can use proc append. just make sure that the column has the same name in each dataset.

proc append base=file1 data=file2; run;

Re: Combine Tables Help

jsasusr — Thu, 25 Jun 2015 19:08:24 GMT

You could try an insert into statement:

proc sql;

insert into table_1

(column1, column2, column3)

select column1, column2, column3

from table_2;

run;

If there is a specific subset from table_2, you can use a where statement after the from statement such as

from table_2

where column2="something";

Re: Combine Tables Help

Reeza — Thu, 25 Jun 2015 19:24:47 GMT

Tasks>Data>Append Table

Re: Combine Tables Help

Tom — Thu, 25 Jun 2015 21:49:37 GMT

So to combine two tables without matching the rows you can use the SET statement in SAS.

data want;

set a b ;

run;

Or if you have some ID variables that the two datasets are sorted on you can use a BY statement to insure that the generated table is also sorted.

data want;

set a b ;

by id ;

run;