topic please help me through this code in SAS Programming

please help me through this code

Ravikumarkummari — Sat, 24 Jan 2015 18:39:02 GMT

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

Re: please help me through this code

Reeza — Sat, 24 Jan 2015 18:48:52 GMT

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.

Re: please help me through this code

Ravikumarkummari — Sun, 25 Jan 2015 15:56:52 GMT

yes same structure it contains

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

Re: please help me through this code

Reeza — Sun, 25 Jan 2015 16:16:27 GMT

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

Re: please help me through this code

Ravikumarkummari — Sun, 25 Jan 2015 16:20:15 GMT

i dont know how to automate this

that's why i drop a comment in sas community

Re: please help me through this code

Reeza — Sun, 25 Jan 2015 17:01:40 GMT

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.