06-01-2016 04:29 AM
1) This ist the description of the current situation:
The input data sources for the analysis is:
The goal is to:
2) Since I am new to the software, I find it hard. In fact, I have already spent few days to understand this software. Based on the information above, how can I make the corresponding data jobs? Please send me more detailed information and list the necessary job items/building blocks.
3) Additional dfficulty is to find very good tutorials that describe in easy (not in dull and tedious way) the purpose and the correct usae of the individual building blocks in the data job. Are you familiar maybe with any such tutorial?
06-01-2016 09:47 AM
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.
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
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.