Re: [R] Deduping in R by multiple variables

2012-08-30 Thread ramoss
Thanks for your help guys. I was refering to the variables the wrong way. This worked for me: idx <- !duplicated(detail2[,c("TDATE","FIRM","CM","BRANCH", "BEGTIME", "ENDTIME","OTYPE","OCOND", "ACCTYP","OSIDE","SHARES","STOCKS", "ST

Re: [R] Deduping in R by multiple variables

2012-08-29 Thread William Dunlap
irst (in the working example) and R hung, there might be ways to speed up the process. Bill Dunlap Spotfire, TIBCO Software wdunlap tibco.com > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On > Behalf > Of ramoss > Sen

[R] Deduping in R by multiple variables

2012-08-29 Thread ramoss
I have a dataset w/ 184K obs & 16 variables. In SAS I proc sort nodupkey it in seconds by 11 variables. I tried to do the same thing in R using both the unique & then the !duplicated functions but it just hangs there & I get no output. Does anyone know how to solve this? This is how I tried to d