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.weyla...@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.abne...@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]] ______________________________________________ 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 and provide commented, minimal, self-contained, reproducible code.
