I have a data in the following format in excel spreadsheet.
Actually the PatientID treatment and Test are given in merged cells.
For example for screening(value is 10) the data is available in the next row.
but PatientID treatment and test are common for first and second rows.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.