proc appenmd-different lengths

Ronein — Tue, 05 Apr 2022 14:23:15 GMT

Hello

I am using proc append.

I get warning "WARNING: Variable OR has different lengths on BASE and DATA files ."

The more serios problem is that the length of variable OR is not enough and I cannot see the full name on output.

Any solution please?

%macro RRR1(CAT);
title "&CAT.";
proc sql;
create table temp as
select "&CAT." as OR   ,
       sum(&CAT. ) as Nr_yes,
	   sum(case when &CAT. ne 1 then 1 else 0 end ) as Nr_No 
from  ttt
;
quit;

proc append base=Wanted  data=temp force  nowarn;
run;
%mend;
%RRR1(CAT=X1);
%RRR1(CAT=X2)
%RRR1(CAT=X3)
%RRR1(CAT=X4)
 
title;
proc print data=wanted noobs;run;

Re: proc appenmd-different lengths

ballardw — Tue, 05 Apr 2022 14:56:41 GMT

Make sure that your base data set has the longest length ever to occur in any of your data you intend to append.

topic proc appenmd-different lengths in SAS Programming

proc appenmd-different lengths

Re: proc appenmd-different lengths