Hi All I read a lot of information about the merging process in SAS, but nothing helped so far. It should be an easy thing. What I want to do: - I have a table with information about customers - I have a table with information about orders --> the one thing in common they have, is a variable with information (firstname lastname). For the customers I concatenated two text variables. Code: /*Sort inputfile with info about customers, has the concatenated variable, one row per customer*/ proc sort data=ECom.kunden; by RechnungAn; run; /*Sort inputfile with info about orders, several rows possible for one customers*/ proc sort data=ECom.bestellungen; by RechnungAn; run; /*do the actual merge*/ data ECom.AlleDaten; merge ECom.kunden ECom.bestellungen; by RechnungAn; run; /*show all*/ proc print data=ECom.AlleDaten; run; The result is one table, but no real merging all information is separately. I would like to have the infos customer - orders, meaning for each order I would like to have more information that is stored at the customer (e.g. address). I could imagine that there is some issue if the variables RechnungAn don't have the same length maybe? Or that the concatenating process messes something up? Thanks a lot for your help!
... View more