Hi, all. I'm new to R. I've been a SAS programmer for 20 years.
I seem to be having trouble with the most basic task - bringing a table in an *.RData file into a data.frame object. Here's how I created the *.RData file. library(RODBC) db <- odbcConnect("*******") df <- sqlQuery( db , "select * from schema.table where year(someDate)=2006" ) save( df , file="C:/Documents and Settings/userName/My Documents/table2006.RData" ) dim(df) remove(df) odbcClose(db) remove(db) detach("package:RODBC") Next, I moved that data file (table2006.RData) to another workstation - not at the client site. Now, I need to get that data file into a data.frame object. I know this should be simple, but I can't seem to find out how to do that. I tried the following. First, after opening R without doing anything, RGui used 35,008 KB of memory. I submitted the following. > debt2006 <- load("T:/R.Data/table2006.RData") Memory used by RGui jumped to 191,512 KB. So, it looks like the data loaded. However, debt2005 is of type character instead of data.frame. > ls() [1] "debt2005" > class(debt2005) [1] "character" > Help, please. Ed Ed Heaton Project Manager, Sr. SAS Developer Data and Analytic Solutions, Inc. 10318 Yearling Drive Rockville, MD 20850 Office: 301-520-7414 ehea...@dasconsultants.com www.dasconsultants.com <http://www.dasconsultants.com/> CMMI ML-2, SBA 8(a) & SDB, WBE (WBENC), MBE (VA & MD) e...@heaton.name (Re: http://www.r-project.org/posting-guide.html) ______________________________________________ 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.