search for: unitid

I have a dataset of property transactions that includes the transaction ID (TranID), property ID (UnitID), and transaction date (TranDt). I need to create a data frame (or data table) that includes the previous transaction date, if one exists. This is an easy problem in SQL, where I just run a sub-query, but I'm trying to make R my one-stop-shopping program. ?The following code works on a subset o...

Hello Experts, how can I use variables in the RODBC environment. Example which does not work: Thanks for your help. Thorsten pn <- '39R5238'; library(RODBC); odbcobj <- odbcConnect("SQUIT21C",uid="muehge",pwd="xxx"); sql <- "select u.unitid, from test where part in ('pn') "; parameter <- sqlQuery(odbcobj,sql); odbcClose(odbcobj);

.... Versions: R-2.7.0 on Windows XP; RODBC_1.2-3 code snippet: r8 <- stepFlexclust(df,8,nrep=100,FUN=kcca, family=kccaFamily("kmedians")) summary(r8) ## returns cluster sizes of 51, 115, 218, 73, 118, 140, 311, and 118 trev <- data.frame(r8@cluster) sqlSave(ch, trev, rownames="unitid") in MySQL: select r8cluster, count(*) from trev group by 1 order by 1 ## returns cluster sizes of 51, 116, 217, 73, 117, 140, 312, 118 problem: 4 of the 8 clusters differ in sizes. They're close but I'd think they should be exact. So ... bug or not a bug? It'd be nice if I w...

Hi, I am wondering if there is a simple way to plot MCF(mean cumulative function) for recurrent events in R? MCF (http://www.weibull.com/hotwire/issue57/relbasics57.htm) And do you have some other recommendation in visualize recurrent events? I did some research online. Some people use ggplot2 to plot MCF, but it requires some additional coding. http://user2010.org/slides/Shentu.pdf Your help

...########## ## EXAMPLE: generate balanced nested data with heteroskedastic errors of ## variance 0.5, 1, 2, or 4 ############################################################################### ngroup <- 50 npergroup <- 20 n <- ngroup*npergroup set.seed(5046) d <- data.frame(unitid = 1:n, groupid = rep(1:ngroup, each=npergroup), verror = sample(c(0.5, 1, 2, 4), size=n, replace=T), x = 0.1*rnorm(n)) groupeffx <- data.frame(groupid = 1:ngroup, theta = rnorm(ngroup, sd = 0.25)) d <- merge(d, groupeffx) d$etrue <- rnorm(n, sd = sqrt(d$verror)) d$y <- 5...

...P version 3.0 Status: RQ=32 Iso- ArqSz=2 Cal=3 SBA+ ITACoh- GART64- HTrans- 64bit- FW- AGP3+ Rate=x4,x8 Command: RQ=1 ArqSz=0 Cal=0 SBA+ AGP+ GART64- 64bit- FW- Rate=x8 Capabilities: [d0] HyperTransport: Slave or Primary Interface Command: BaseUnitID=0 UnitCnt=17 MastHost- DefDir- DUL- Link Control 0: CFlE- CST- CFE- <LkFail- Init+ EOC- TXO- <CRCErr=0 IsocEn- LSEn- ExtCTL- 64b- Link Config 0: MLWI=16bit DwFcIn- MLWO=16bit DwFcOut- LWI=16bit DwFcInEn- LWO=16bit DwFcOutEn- Link Control 1: CFlE...

...0 Host bridge: Advanced Micro Devices [AMD] RS780 Host Bridge Subsystem: Advanced Micro Devices [AMD] RS780 Host Bridge Flags: bus master, 66MHz, medium devsel, latency 0 Capabilities: [c4] HyperTransport: Slave or Primary Interface Capabilities: [54] HyperTransport: UnitID Clumping Capabilities: [40] HyperTransport: Retry Mode Capabilities: [9c] HyperTransport: #1a Capabilities: [f8] HyperTransport: #1c 00:01.0 PCI bridge: Advanced Micro Devices [AMD] RS780 PCI to PCI bridge (int gfx) (prog-if 00 [Normal decode]) Flags: bus master, 6...

*RESEND* due to exceeding the mailinglists limit for attachment size. Hi, I''m trying to get secondary vga-passthrough on a HVM guest to work with a AMD HD6570 and the native kernel radeon driver and kernel modesetting. So the guest still gets the emulated stdvga or cirrus device(used in my case here) as primary/boot vga adapter. - When i don''t passthrough the radeon card, the