BookmarkSubscribeRSS Feed
saslover
Calcite | Level 5
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.
3 REPLIES 3
Pritish
Quartz | Level 8
Is there any white space between the variables in the same cell?
saslover
Calcite | Level 5
Yes.. It is separated by a single white space.
Doc_Duke
Rhodochrosite | Level 12
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1411 views
  • 0 likes
  • 3 in conversation