@ldixon
Ehhmm... What's the problem? Everything appears to work as it should.
Is the Note "has . observations" bothering you. If so then that's not an issue but what you get as SAS Note when appending to database tables (because this information is not available from a database table without executing Select Count(*) but it is available from SAS tables as a table attribute).
This only means that SAS doesn't know how many rows your database table has.
Proc Append is the right way for appending data to a table. When appending to a database table then you might want to investigate libname options INSERTBUFF and DBCOMMIT to improve performance.
... View more