https://communities.sas.com/t5/SAS-Programming/reading-data-from-merged-cells/m-p/22803#M3722 there are a variety of tedious but possible ways to read in such abnormally presented data, but my gut feeling is that you will be much better off if you can clean up the data from your source Excel spreadsheet to eliminate this kind of abnormality. Tue, 01 Dec 2009 20:46:22 GMT abdullala 2009-12-01T20:46:22Z https://communities.sas.com/t5/SAS-Programming/reading-data-from-merged-cells/m-p/22802#M3721 I have a data in the following format in excel spreadsheet.<BR /> Actually the PatientID treatment and Test are given in merged cells.<BR /> For example for screening(value is 10) the data is available in the next row.<BR /> but PatientID treatment and test are common for first and second rows.<BR /> <BR /> <BR /> Patient--Treatment--Test--Screening---Day1---Day2--Day3--Day5<BR /> <BR /> 1---------------X------------A---------------------- 20-------20-------30-------40 <BR /> ----------------------------------------10<BR /> <BR /> How can I make a dataset with this kind of data in such a way that<BR /> for each patient all data should be available in one row. Mon, 30 Nov 2009 11:21:31 GMT https://communities.sas.com/t5/SAS-Programming/reading-data-from-merged-cells/m-p/22802#M3721 A_B_C 2009-11-30T11:21:31Z https://communities.sas.com/t5/SAS-Programming/reading-data-from-merged-cells/m-p/22803#M3722 there are a variety of tedious but possible ways to read in such abnormally presented data, but my gut feeling is that you will be much better off if you can clean up the data from your source Excel spreadsheet to eliminate this kind of abnormality. Tue, 01 Dec 2009 20:46:22 GMT https://communities.sas.com/t5/SAS-Programming/reading-data-from-merged-cells/m-p/22803#M3722 abdullala 2009-12-01T20:46:22Z