topic multiply lengths for variable (in character) while merging files in SAS Procedures

multiply lengths for variable (in character) while merging files

mei — Fri, 22 Jun 2012 05:23:46 GMT

I am trying to append/merge several files and i have this warning message"

Data gompers.gompers_2001_2011;

set gompers.gompers_2000_2001

gompers.gompers_2002_2005

gompers.gompers_2006

gompers.gompers_2007_2009_my

gompers.gompers_2010_my;

run;

WARNING: Multiple lengths were specified for the variable CONAME by input data set(s). This may

cause truncation of data.

coname is the company name.

the length for this variable is 48 for the 3 original files and 70 for 2007_2009 and 2010 file.

how do i solve this problem. do i go back to all original file and increase the length-how do we write that codes?

Re: multiply lengths for variable (in character) while merging files

shivas — Fri, 22 Jun 2012 05:56:34 GMT

Hi,

You can try like this...as 2007_2009 and 2010 file has maximum length.

Data gompers.gompers_2001_2011;

set gompers.gompers_2007_2009_my

gompers.gompers_2010_my;

gompers.gompers_2000_2001

gompers.gompers_2002_2005

gompers.gompers_2006

run;

or add length statement before set statement ;

Data gompers.gompers_2001_2011; length coname $ 70.;

set gompers.gompers_2000_2001

gompers.gompers_2002_2005

gompers.gompers_2006

gompers.gompers_2007_2009_my

gompers.gompers_2010_my;

run;

Thanks,

Shiva

Re: multiply lengths for variable (in character) while merging files

Alpay — Fri, 22 Jun 2012 06:02:31 GMT

SAS assigns the length of a variable when it is seen first time.

If the order of the data sets does not matter you can place the data sets with length 70 before the data sets with lenght 48 in set statement.

Data gompers.gompers_2001_2011;

set

gompers.gompers_2007_2009_my

gompers.gompers_2010_my

gompers.gompers_2000_2001

gompers.gompers_2002_2005

gompers.gompers_2006

;

run;

If the order of the data sets matters in set statement you can use a length statement before set statement to specify the length of the variable coname.

Data gompers.gompers_2001_2011;

length coname $70;

set gompers.gompers_2000_2001

gompers.gompers_2002_2005

gompers.gompers_2006

gompers.gompers_2007_2009_my

gompers.gompers_2010_my;

run;