please help me through this code

[Ravikumarkummari]

Hiiiii all,
solve this query
suppose some insurance data is availabe in D:\kumar folder.
in that year wise information is there. in folders ex:2003-2013(these are 10 folders)
again in each folder sub folders are there for month wise january-june.
and in each month some datasets are there respective to that month.
example in january information is in the form of datasets like(data_a, data_b, data_c) same type of data sets are availabe in all months.
now you should got my point.
(2003)-(january-june), (data_a,data_b,data_c)
-
-
-
-
-
2013-,(january-june) , (data_a,data_b,data_c)

now i have question that i need final output is "final_data_a" , "final_data_b", "final_data_c"
the final_data_a is contain all the ("data_a") datasets in all over 10years years. i.e. merging of all 2003-2013 (january-june) data_a(dataset)

how to automate this code can any one explain by using sas-macros

[Reeza]

Do all of your files have the same structure/variables?

This is a frequently asked question, you can try searching on here using "importing multiple text files" to see many different solutions.

[Ravikumarkummari]

yes same structure it contains

suppose in each dataset it contain variables  like policy_id , policy_hlder_name,  policy_amt.

[Reeza]

I would suggest marking this one assumed answered and moving the discussion to the other thread.

[Ravikumarkummari]

i dont know how to automate this

that's why i drop a comment in sas community

[Reeza]

You can ask questions here, but your question is too broad and seems like you want someone to do the work for you without illustrating what you've tried.