Basically, PROC APPEND is more strict with variable types than SET statement, which just pounds two (or more) datasets together regardless of their structure.

Here is a more detailed reference: http://darkwing.uoregon.edu/~robinh/061appl_data.txt.