On 06/07/2012 3:30 PM, C W wrote:
Has anyone read SAS file .sas7bdat into R. The above suggestions don't work.
They work if you follow them. Duncan Murdoch
-M On Fri, Jul 6, 2012 at 3:06 PM, David Winsemius <[email protected]>wrote: > > On Jul 6, 2012, at 2:49 PM, C W wrote: > > Hey, David >> >> table(count.fields()) is telling me have 11 columns, but I have way more, >> more like 30 columns. >> > table(count.fields("**persistency.csv")) >> >> 1 2 3 4 5 6 7 8 9 11 >> 439384 39617 16130 21993 12556 1900 988 713 61 1 >> >> > I don't usually put back the list address when responding to a private > email, but I'm breaking my rule. You should not send private follow-ups for > threads that start on the list unless there is something that other readers > might not benefit from seeing. > > If it is a CSV file then you need to tell count.fields to use commas: > > table(count.fields("**persistency.csv", sep=",")) > > -- > David. > > >> -M >> >> On Fri, Jul 6, 2012 at 2:36 PM, David Winsemius <[email protected]> >> wrote: >> >> On Jul 6, 2012, at 1:39 PM, C W wrote: >> >> Quick question, what the memory size in R? >> I converted to CSV, but only 53300 of the 1,000,000 rows were read in. >> Did >> R run out of memory? If so, is there a work around? >> >> You probably have mismatched quotes. Consider using quote="". Also >> consider doing this: >> >> table(count.fields(file-name)) # with a valid file name >> >> That count.fields function is very useful since it accepts the same >> arguments as the read.tables functions, with defaults of: >> >> quote = "\"'", skip = 0, blank.lines.skip = TRUE, comment.char = "#") >> >> -- >> David. >> >> Thanks, >> Mike >> >> On Fri, Jul 6, 2012 at 1:24 PM, Duncan Murdoch <[email protected]> >> **wrote: >> >> On 06/07/2012 1:11 PM, C W wrote: >> >> Hi all >> I have a large SAS data set, how do I get it read in R? >> >> The data is too big (about 400,000 rows by 100 columns) to be saved as an >> Excel file. How should I get it read in R? Any packages? I don't seem >> to >> find any. >> >> >> You could write it out in some plain delimited format, e.g. CSV or >> tab-delimited. Watch out for special characters in strings that confuse R >> when it reads it in (e.g. commas in unquoted CSV strings, quotes within >> strings, etc.) >> >> Duncan Murdoch >> >> >> [[alternative HTML version deleted]] >> >> ______________________________**________________ >> [email protected] mailing list >> https://stat.ethz.ch/mailman/**listinfo/r-help<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. >> >> David Winsemius, MD >> West Hartford, CT >> >> >> > David Winsemius, MD > West Hartford, CT > > [[alternative HTML version deleted]] ______________________________________________ [email protected] 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.
______________________________________________ [email protected] 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.
