Truncation of fields to 32 characters without warning
is alive and well.
If the NameRow= option is used in the import.data command
with FileType="EXCEL" then truncation occurs. The workaround
is to drop the "NameRow=" from the command.
Thanks to D. Smith of statsci for quickly verifying this so
that I could proceed to do for a fourth time what I have already
done three times. :(
I wish that statsci would post a list of known bugs so
that I could consult it from time to time to see whether
I have any problems. It is deplorable that statsci has
such information (existence of bugs) and chooses not
to make this information available to users.
Had such a facility been in oexistence, I would have
checked it before using import.data for the first
time, and perhaps and perhaps I would not
have incurred such a monumental and needless
waste of time.
Regards,
Bruce
********************* SCRIPT FILE ******************************
import.data("marrev.dat","c:\\data\\bia\\radmar00\\marrev.xls",FileType="EXCEL",NameRow=1,StringsAsFactors="Never")
marrev1.dat <-
read.table("c:\\data\\bia\\radmar00\\marrev.csv",sep=",",header=T,row.names=NULL,as.is=T)
marrev.dat$market[113]
marrev1.dat$market[113]
***********************OUTPUT****************************************
> import.data("marrev.dat",
"c:\\data\\bia\\radmar00\\marrev.xls", FileType
= "EXCEL", NameRow = 1, StringsAsFactors =
"Never")
> marrev1.dat <- read.table(
"c:\\data\\bia\\radmar00\\marrev.csv", sep =
",", header = T, row.names = NULL, as.is = T)
> marrev.dat$market[113]
[1] "Greensboro-Winston Salem-High P"
> marrev1.dat$market[113]
[1] "Greensboro-Winston Salem-High Point"
================WORK-AROUND=====================
remove "NameRow=1" from the import.data command
-----------------------------------------------------------------------
This message was distributed by s-news@wubios.wustl.edu. To unsubscribe
send e-mail to s-news-request@wubios.wustl.edu with the BODY of the
message: unsubscribe s-news
|