topic importing excel-multiple variables in one cell in Statistical Procedures

importing excel-multiple variables in one cell

saslover — Tue, 07 Jun 2011 19:20:49 GMT

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.

Re: importing excel-multiple variables in one cell

Pritish — Tue, 07 Jun 2011 19:57:12 GMT

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

Re: importing excel-multiple variables in one cell

saslover — Tue, 07 Jun 2011 20:51:57 GMT

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

Re: importing excel-multiple variables in one cell

Doc_Duke — Tue, 07 Jun 2011 20:55:27 GMT

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