Programming the statistical procedures from SAS

importing excel-multiple variables in one cell

Reply
Occasional Contributor
Posts: 13

importing excel-multiple variables in one cell

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.
Contributor
Posts: 65

Re: importing excel-multiple variables in one cell

Is there any white space between the variables in the same cell?
Occasional Contributor
Posts: 13

Re: importing excel-multiple variables in one cell

Yes.. It is separated by a single white space.
Trusted Advisor
Posts: 2,114

Re: importing excel-multiple variables in one cell

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
Ask a Question
Discussion stats
  • 3 replies
  • 139 views
  • 0 likes
  • 3 in conversation