[SOLVED] Converting data from one format to the other

view full story

http://www.unix.com – Hi All, I need to convert an exel spreadsheet into a SAS dataset, and the following format change is needed. Please help, this is too complex for a biologist. Let me describe the input. 1st row is generation.1st column in keyword 'generation', starting 2nd column there are 5 generations in my actual data, I have shown 3 here, namely G1,G2 and PAR. 2nd row is family name,1st column is keyword 'gene', from 2nd column format is NameParent1-NameParent2-RandomNumber_Replicate. If 'Parent' is present in the name, then format is NameParent-Parent-RandomNumber_Replicate and it should be include (HowTos)