topic Re: Merge data with a variable of different length in SAS Procedures

Merge data with a variable of different length

caveman529 — Fri, 07 Jun 2013 17:37:38 GMT

Hi, everyone:

I hope to merge 10 datasets into one by using the following:

data want;

set x1 - x10;

run;

But SAS reports that "Multiple lengths were specified for the variable case_no by input data set(s). This may cause truncation of data." Could you please tell me how to specify the length in for want dataset so that when I combine small datasets x1 - x10, there is no truncation?

Thank you!

Re: Merge data with a variable of different length

LinusH — Fri, 07 Jun 2013 17:58:32 GMT

First figure out how long case_no is when it's "longest". Then insert a length or an attrib statement prior to the set.

Re: Merge data with a variable of different length

PGStats — Fri, 07 Jun 2013 18:05:57 GMT

Simply state a length for case_no that is as large as the largest one :

data want;

length case_no $30;

set x1-x10;

run;

Re: Merge data with a variable of different length

caveman529 — Sat, 08 Jun 2013 05:31:31 GMT

Thank you for your help. It works