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
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.
yes same structure it contains
suppose in each dataset it contain variables like policy_id , policy_hlder_name, policy_amt.
i dont know how to automate this
that's why i drop a comment in sas community
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.