01-24-2015 01:39 PM
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.
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
01-24-2015 01:48 PM
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.