importing excel-multiple variables in one cell

[saslover]

How do I import an excel file that has multiple variables in one cell? For instance
1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17

The item in bold italic is in one cell. How do I separate it into multiple variables. The variables are id,day,sex,phase,date,a1,a2,a3,a4

It has to look like
obs id day sex phase date a1 a2 a3 a4
1 1001 1 M Day 2 3/16/2011 >276 1.3 >1655 0.17

Also the observations in the excel start from 16th or 17th row. The first few rows has other info that are junk. How do I read in data from here and get rid of the junk above.

Thanks a lot for your help.

[Pritish]

Is there any white space between the variables in the same cell?

[saslover]

Yes.. It is separated by a single white space.

[Doc_Duke]

Please see my post under SAS Procedures, and,please, please, just post a question to one forum. Otherwise you are wasting people's time and the threads get convoluted.

Thanks,
Doc