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 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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.