Hello everyone, Massive thanks for your responses. They were both a learning lesson and constructive feedback. : ) The solution to this problem can be seen from PROC Star, mkeintz, and Ksharp code replies. Reeza you gave me a partial solution but it did show me a different approach to this problem, so you have my thanks! I selected PROC star as the solution as it was the simplest to include into the main program I am working with. Mkeintz SAS code using hash is awesome. However, my experience with hash is not at a level that I feel comfortable with (I have seen this method of coding in SAS at many SUG conferences). Thank you mkeintz. Ksharp code works well but it appeared that I didn’t need the PROC SQL or the DATA NULL steps. Big thanks Ksharp! On a side note, I had to modify the code for my purposes because the file was much, much longer than the example provided to this blog chain. Using PROC star’s code on the original data resulted in an ERROR message after the PROC step that stated “ERROR: The ID value "KCFi551" occurs twice in the same BY group.” ERROR: Too many bad BY groups.“ I had to insert the LET option for PROC TRANSPOSE, which allows duplicate values of an ID variable. (http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p1r2tjnp8ewe3sn1acnpnrs3xbad.htm) (http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n0mwa670j36v2an1ojkae8e3d8sz.htm). After doing that the program produced the desired output needed using the original text file. Massive thanks everyone and Happy New Year!!!
... View more
