06-20-2016 11:36 AM
I would like to append 16 datasets having same column and variables name. I would like to do that using macro to stack each table
and create one with new variable having dataset name to distinguish the data in merged table.
Example : I have Table Customer and Client having variable as A ,B,C, D..and soon on.
Would like to create one table MERGED
AS data from both table and new variable
A B NEW_VARIABLE
1 0 Customer_file
1 0 Client_file
So that data can be differentiated based on New_variable.?
06-20-2016 01:01 PM
Sorry, I don't understand the question. The simple code provided concatenates datasets A, B, C etc. and adds NEW_VARIABLE to the resulting dataset with the name of the dataset of origin. Do you mean some other sort of merging operation? Are you asking for a macro variable or macro program?
Need further help from the community? Please ask a new question.