DATA Step, Macro, Functions and more

PROC APPEND with new columns

Reply
Contributor
Posts: 22

PROC APPEND with new columns

Hi.

 

I have a table A like this:

Name Amount1
aaa       32
bbb       23

Another table B like this

Name Amount2
ccc        41
ddd       14

I try to append them in a C table like this:

Name Amount1 Amount2
aaa       32               .
bbb       23               .
ccc        .                41
ddd      .                  14

I do this

data C;
set A;
run;

PROC APPEND BASE=C DATA=B force;QUIT;

And I have this two warnings:

WARNING: Variable Amount2 was not found on BASE file. The variable will not be added to the BASE file.
WARNING: Variable Amount1 was not found on DATA file.

Finally my table C doesn't have the Amount2 column.

How can I manage it?

 

Thanks for answer

PROC Star
Posts: 252

Re: PROC APPEND with new columns

[ Edited ]

proc appends by name as you have different names as amount1 and amount2, they are trated as sperate variables. you have 2 options here. First one  is rename amount 2 to amount1 or  do insert as insert does not care for names and appending is done by position

 

proc sql;

insert into tableA

select * from tableB;

Super User
Posts: 17,829

Re: PROC APPEND with new columns

PROC APPEND cannot add new variables.

If that's what you need use either a data step or SQL union.

 

data want;

set tableA tableB;

run;
Ask a Question
Discussion stats
  • 2 replies
  • 73 views
  • 0 likes
  • 3 in conversation