Great, thanks for your help! ... View more

Excellent thanks again ... View more

Thank you very much for your help Cynthia ... View more

Excellent. Thanks. ... View more

That's great thanks for your help and apologies for my typo in the original question. I wish I could mark both as correct answer. ... View more

Thanks your clarify . Anyway, I am still going to keep an eye on GA . ... View more

Linlin wrote: I would create files with the first two columns using  ‘infile’ statement, then combine these files with files created by proc import: Data want;   merge cvs1_part1  cvs1_part2(drop=column_1 column_2);   Run; Thanks very much, that worked! Simple when you know how . Thanks to everyone for your help. ... View more

Thanks to everyone for the help as you have all contributed. I wish I could give you all the correct answer as Reeza had the initial idea of structuring the data in this way, Bruce elaborated further on it, but I have set the correct answer to Astounding for taking the ideas and putting them into code for me. Many thanks to all. ... View more