Hi,
I think what you are looking to do (rather how I understand it) is to link the different datasets to have a combined dataset.
Easiest way that I can think of is to use PROC SQL for this as there seems to be couple of fields with different names that needs to be joined. If you are new to SQL, please do some reading on the topic because the different joins will produce different results. (This paper should help http://www.lexjansen.com/nesug/nesug09/bb/BB03.pdf)
If for example you want to join/link Client and H_file information and you assume that Client has all the information you could do the following.
proc sql; create table client_HComb as select c.Client_Company, c.Client_Company2, c.Client_Firstname, c.Client_Lastname, h.Firstname, h.Lastname, h.Comapny_Name from client c left outer join h_file h on c.Client_Firstname=h.firstname and c.Client_Lastname=h.Lastname and c.Client_Company = a.Comapny_Name ; quit;
With the left join, if no matches from the H_file (right table) is found the fields from H_file will be missing.
Similar results can be accomplished with Datastep merge but there's a couple of extract hoops that you'll need to jump through.
But important read up on SQL before hand.
Best site I can suggest to find tutorials are www.lexjansen.com. Most of the papers presented at conferences are there and if covers from basics to advance. That is my one of my first stops when I need to find something.
HTH
KR
H
... View more