Hi Michael,

Thanks for your responses.

When I do this, I am not successful. What am I doing wrong?

> data3<-
+ "OBSNOAGESEXALKPHOSLABCAMMOLPHOSMMOLAGEGROUP
+ 2176M8453.20.93
+ 2276M52.180.843
+ 2368M8252.150.521
+ 2469M8452.31.361
+ 2576F100325.31.073
+ 2670F903200.972
+ 2771F109322.30.942
+ 2870-9965324.31.422
+ 2974F613250.872
+ 3074F62323.30.942"
>
>
> data3<-read.table(textConnection(data3),
+    header=TRUE,sep=" ",
+    row.names="OBSNO")
Error in data[[rowvar]] : attempt to select less than one element
> closeAllConnections()
> data3
[1]
"OBSNOAGESEXALKPHOSLABCAMMOLPHOSMMOLAGEGROUP\n2176M8453.20.93\n2276M52.180.843\n2368M8252.150.521\n2469M8452.31.361\n2576F100325.31.073\n2670F903200.972\n2771F109322.30.942\n2870-9965324.31.422\n2974F613250.872\n3074F62323.30.942"
>

> data3<-read.table(textConnection(data3),
+    header=TRUE,sep="\t",
+    row.names="OBSNO")
Error in data[[rowvar]] : attempt to select less than one element
> closeAllConnections()
> data3
[1]
"OBSNOAGESEXALKPHOSLABCAMMOLPHOSMMOLAGEGROUP\n2176M8453.20.93\n2276M52.180.843\n2368M8252.150.521\n2469M8452.31.361\n2576F100325.31.073\n2670F903200.972\n2771F109322.30.942\n2870-9965324.31.422\n2974F613250.872\n3074F62323.30.942"
>




On Thu, Jan 19, 2012 at 11:45 AM, R. Michael Weylandt <
michael.weylandt@gmail.com> wrote:

> Simply change the sep  = "," argument of read table: " " for a space
> and "\t" for a tab. E.g., read.table(text = data3, sep = " ", header =
> TRUE)
>
> Take a look at ?read.table for more info about the sep argument (In
> particular the special behavior of the default sep = "")
>
> Thanks for the well-posed question and working data.
>
> Michael
>
> On Thu, Jan 19, 2012 at 11:37 AM, Dan Abner <dan.abner99@gmail.com> wrote:
> > Hello everyone,
> >
> > I use Bob Muenchen's approach for reading in "in-stream" (to use SAS
> > parlance) delimited data within a script. This works great:
> >
> >
> > mystring <-
> > "id,workshop,gender,q1,q2,q3,q4
> >  1,1,f,1,1,5,1
> >  2,2,f,2,1,4,1
> >  3,1,f,2,2,4,3
> >  4,2, ,3,1, ,3
> >  5,1,m,4,5,2,4
> >  6,2,m,5,4,5,5
> >  7,1,m,5,3,4,4
> >  8,2,m,4,5,5,5"
> >
> > mydata <- read.table( textConnection(mystring),
> >   header=TRUE, sep=",",
> >   row.names="id", na.strings=" ")
> > closeAllConnections()
> > mydata
> >
> > Can anyone suggest a similar approach for reading in tab-delimited or
> > single space delimited data? Example data:
> >
> > data3<-
> > "OBSNO AGE SEX ALKPHOS LAB CAMMOL PHOSMMOL AGEGROUP
> > 21 76 M 84 5 3.2 0.9 3
> > 22 76 M  5 2.18 0.84 3
> > 23 68 M 82 5 2.15 0.52 1
> > 24 69 M 84 5 2.3 1.36 1
> > 25 76 F 100 3 25.3 1.07 3
> > 26 70 F 90 3 20 0.97 2
> > 27 71 F 109 3 22.3 0.94 2
> > 28 70 -99 65 3 24.3 1.42 2
> > 29 74 F 61 3 25 0.87 2
> > 30 74 F 62 3 23.3 0.94 2"
> >
> > Thanks!
> >
> > Dan
> >
> >        [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
> > and provide commented, minimal, self-contained, reproducible code.
>

	[[alternative HTML version deleted]]

