topic Re: Different variable length during combining table in SAS Data Science

Different variable length during combining table

mlogan — Thu, 21 May 2015 19:43:48 GMT

Hi there,

I tried to merge two table where variable lengths are different in two different table for the same variable. Can anyone help me writing the code to add these two table with set statement plco.

Table1:

Student_ID Name

101 John

103 Allison

105 Michael

Table2:

Student_ID Name

107 Johan

109 Chowdhury

Thanks,

Re: Different variable length during combining table

ballardw — Thu, 21 May 2015 19:47:06 GMT

easiest is to override the length before the set.

data want;

length student_id $ 5 name $ 25; /* what ever lengths you might need*/

merge table1 table2;

by student_id;

run;

OR instead of merge:

set table1 table2;

depending on what you are attempting to do.

Re: Different variable length during combining table

mlogan — Thu, 21 May 2015 20:25:04 GMT

Thanks ballardw,

I need the set statement and it worked when I write 'set Table2 Table1', but some observation doesn't come to it's total length when I write 'set Table1 Table2',. It's because variable 'Chowdhury' is bigger then any other variables. Do you know a solution to make it work for 'set Table1 Table2'. let's say for the following table. Thanks,

Table1:

Student_ID Name Course

101 John Math

103 Allison English

105 Michael Geography

Table2:

Student_ID Name Course

107 Johan Math

109 Chowdhury English

Re: Different variable length during combining table

ballardw — Thu, 21 May 2015 20:29:17 GMT

Did you try adding the length statement before the SET statement? Did you make the length at least as long as the longest value of the variables concerned?

Re: Different variable length during combining table

Ksharp — Fri, 22 May 2015 13:22:38 GMT

SQL could take care of it .

proc sql;

create table want as

select * from A

union all corr

select * from B ;

quit;

Xia Keshan