Recent content by jfca283

  1. J

    Calibrate survey using rake

    Hello, I need to calibrate a survey using raking. I already declared the complex design here: des_survey <- svydesign(id= ~idd, strata= ~strata, data = datos, weights = ~ft, check.strata=TRUE ) options(survey.lonely.psu = "remove") options(digits = 10) However, when I run the rake process...
  2. J

    Tabulate two variables by a third one

    Hello, I'm trying to avoid a loop to do this zz=matrix(NA, nrow=40,ncol=1) for (i in 1:40) { wer=table(id[qwe==i],strata[qwe==i]) df=nrow(wer)-ncol(wer) zz[i]=df } The variable qwe goes from 1 to 40, and I need the nrow-ncol from a crossing two variables (id, strata) Is It possible to...
  3. J

    bootstrapping - change in time using complex survey

    Hi, My problem seems simple, but I'm a bit lost. I have two variables, X1 and Y1. X1 and Y1 are the way a product is classified by the team X1 and Y1. X1: team X1 coding Y1: team Y1 coding And I need to test if the change (relative) between t and t+12 is different or not when I compare X1 and...
  4. J

    lapply and svyratio

    Hello, I need to compute some ratios using a survey. I manage to calculate regional totals after especifying a list of variables (regions). Regions are dummies from 1 to 17, taking the value of 1 if the observation belongs to the region1. This code works. It computes totals by regions using the...
  5. J

    Matrix rownames from variable levelsof

    Hello, I'm writing a code and I need to name the matrix row names with the local created from levelsof applied to var1 (variable 1). I already created the matrix using as reference a local (levels) using levelsof length. I tried something simple as this matrix rownames=`levels' Stata returned...
  6. J

    concatenate - Loop with variables

    Forget this. With "lapply" I did it. By the way, I still need to concatenate the dummies to the original data frame...
  7. J

    concatenate - Loop with variables

    Hi, I need to obtain a set of dummies. Then I need to concatenate every one of them I generated in my simple loop. And that's what I can't figure it out. c=seq(from=1, to=200) region=round(runif(200,min=1,max=10),0) cise=round(runif(200,min=0,max=6),0) data=cbind(c,region,cise) attach(data)...
  8. J

    concatenate - Loop with variables

    Hello, I have a data frame. I generated some dummies using a simple loop. However, I can't concatenate the dummies to the original data frame. yyy=max(region) for (i in 1:yyy) { nam=paste("region",i,sep="") assign(nam,as.numeric(cise>0 & region==i))...
  9. J

    How can I report common strings in array/dataframe

    Thanks, Dason. You are very kind. I think this thread is solved.
  10. J

    How can I report common strings in array/dataframe

    Of course, dat <- data.frame(a = letters[1:5], b = letters[2:6], c = letters[3:7]) I need to perform some function to retrieve the non commons letters considering the three columns in order to export the non common letters to a vector or colum as: vector<-a, f, g I already know that using...
  11. J

    How can I report common strings in array/dataframe

    Your code worked great. One final question, what do I need to edit in order to obtain the opposite to the intersection? I mean, the rows that are not shared in every column? Thanks for your sintax, Dason. Very simple and fast.
  12. J

    How can I report common strings in array/dataframe

    I just need a vector reporting only the "strings" that exist, or are common, considering all the columns from the data frame or matrix. I don't care the row order of a "string" to report. Only the existence is the relevant. The example I provided with the images tries to explain that. Sorry if I...
  13. J

    How can I report common strings in array/dataframe

    Hello, I have no idea how to report in a vector the commons variables from a data.frame or matrix. I have a data many columns. In this example I show four columns with d1-d4 as names. So, how do I create a vector with the common strings? Something as this: It looks simple, but...
  14. J

    Loop exporting to excel file- writeWorksheetToFile

    I've made some test I found out that the package XLConnect isn't reliable when you try to make some loops. So, I just decided to append every database and after the last file is appended, I've exported using the XLConnect package. If you ask me how do I know the package XLConnect fails, It is...
  15. J

    Loop exporting to excel file- writeWorksheetToFile

    Hi, I need to read multiple dta files and exporting the content of a variable called "name". My idea is to aggregate to the right each "name" from each dta file. I made a simple loop and I know It works reading the dta files. However, It can't say the same exporting the data. Here is what I...