topic Re: How can we avoid warnings while Proc Append multiple datasets in Do loop? in SAS Programming

How can we avoid warnings while Proc Append multiple datasets in Do loop?

akshayn951 — Tue, 19 Jan 2021 04:48:53 GMT

Hello,

I used following code for appending multiple datasets in macro code %Do loop.

Proc Append base= DataJoin data= ABC_join&i force; run;

where i = 1 to n

but I'm getting warnings like

"Variable XYZ has different lengths on BASE and DATA files (BASE 16 DATA 15)."

I used force option.

also used option varlenchk=nowarn; in code but still it is showing same warnings

any other way is there to avoid these warnings?

Thanks.

Re: How can we avoid warnings while Proc Append multiple datasets in Do loop?

SASKiwi — Tue, 19 Jan 2021 06:07:10 GMT

Why do you want to avoid the warnings? They are there for a reason and can alert you to possible data truncation.

Re: How can we avoid warnings while Proc Append multiple datasets in Do loop?

ChrisNZ — Tue, 19 Jan 2021 06:35:49 GMT

Make the variables the correct length to avoid that very valid warning.

Re: How can we avoid warnings while Proc Append multiple datasets in Do loop?

ballardw — Tue, 19 Jan 2021 15:49:46 GMT

Would I be correct in assuming that your data= ABC_join&i data sets are coming from Proc Import?

Proc Import makes assumptions as to variable type and length for each data set created and so has no guarantee that the lengths or even types of the same named variables will be the same.

Best is to read the data in the proper form at the outset.

Second, and tedious, is to have a step "adjust" things.

Third, how do you know that the length of the variable assigned in the Base data set is correct, i.e. long enough to hold the longest valid value?