topic Re: How to append a table if it has more columns than base table used to append. in SAS Programming

How to append a table if it has more columns than base table used to append.

gyambqt — Tue, 09 May 2017 09:16:58 GMT

Hi expert,

i have a base table contain 5 columns and I have appending table has 8 columns.

the 5 columns are included within the 8 column.

when I use proc append with force option. The 3 columns not included are disappearing.

how do I append them using proc append and I can accept missing value

after appending.

thanks

RW9 — Tue, 09 May 2017 09:22:32 GMT

Alwyas a good idea to post test data in the form of a datastep. At a guess a simple set can do this:

data work.test1;
  a=1;
  b=4;
  c="1";
run;

data work.test2;
  a=.;
  c="RTY";
run;

data work.test3;
  c="";
run;

data want;
  set test:;
run;