I am currently working on two sets of tables:
1) 200k+ records
2) 1k+ records
I would like to append the table2) into table1) each month but the most importantly, the table structure for both tables are not 100% the same. (with most of the variables in common)
Some of the variables contain the same nature of data but they are in different variable names.
Moreover, I reckon that the Cantonese wordings are not working while importing (either for the variable name or the cell inside) Does it normal that SAS is not supporting all the cantonsee wordings or something wrong with my importing procedure?
Please kindly help on appending the table. Many thanks for your great help.
You will probably want to use the DATA step to do the appending, although a SQL step would work as well. Either way this will give you the opportunity to rename as needed. Be aware also of variables with differing attributes (length, labels, etc.). It is very possible that the change in language will also be a factor in the variable names.
Share some code or let us know how much detail you need to move forward.