topic Re: Merging Dataset Dynamically with New Column Name added to specify file name in SAS Programming

Merging Dataset Dynamically with New Column Name added to specify file name

sdixit — Mon, 20 Jun 2016 15:36:08 GMT

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.

Please suggest.

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.?

Re: Merging Dataset Dynamically with New Column Name added to specify file name

PGStats — Mon, 20 Jun 2016 16:43:15 GMT

Use set statement option indsname=

data all;

set A B C D E F G indsname=dsn;

NEW_VARIABLE = dsn;

run;

Re: Merging Dataset Dynamically with New Column Name added to specify file name

sdixit — Mon, 20 Jun 2016 16:47:16 GMT

Yes, The value of the new variable is same as the dataset name. That's why I need to write it in a macro. Please suggest

Re: Merging Dataset Dynamically with New Column Name added to specify file name

PGStats — Mon, 20 Jun 2016 17:01:04 GMT

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?

Re: Merging Dataset Dynamically with New Column Name added to specify file name

sdixit — Mon, 27 Jun 2016 13:46:16 GMT

I have created this through SQL while calculating percentage difference between two values and displayed in a table.