please help me through this code

Reply
Frequent Contributor
Posts: 111

please help me through this code

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

Super User
Posts: 19,805

Re: please help me through this code

Posted in reply to Ravikumarkummari

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.

Frequent Contributor
Posts: 111

Re: please help me through this code

yes same structure it contains

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

Super User
Posts: 19,805

Re: please help me through this code

Posted in reply to Ravikumarkummari

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

Frequent Contributor
Posts: 111

Re: please help me through this code

i dont know how to automate this

that's why i drop a comment in sas community

Super User
Posts: 19,805

Re: please help me through this code

Posted in reply to Ravikumarkummari

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.

Ask a Question
Discussion stats
  • 5 replies
  • 335 views
  • 0 likes
  • 2 in conversation