Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Loop over variables with svyset


From   "Stas Kolenikov" <skolenik@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Loop over variables with svyset
Date   Tue, 18 Nov 2008 17:12:06 -0600

switch the order of the cycles, then. First loop over the variables,
then over waves:

forvalues k=1/999 {
  if `k' < 100 local k 0`k'
  if `k' < 10 local k 0`k'
  forvalues year=1/9 {
    * do whatever with variable Q`k'_0`year'
  }
}

On 11/18/08, Daniel Schultz <schultzd@tcd.ie> wrote:
> Hej Stas......
>   Your suggestion looked quite nice....
>  but when I was testing it....it is doing first all of the Variables of
>  the Year 2002 and than 2003 and so on.
>  This is not exactly what I wanted....I need, that the svyset changes
>  every time the Variable changed. Otherwise it would took me ages to
>  bring all the variables together in one table (for one year).
>
>  I am pretty sure it is doable, but I don't really know how.
>  thanks for all your comments so far.
>  Best
>
> Daniel
>
>
>
>  ---------- Forwarded message ----------
>  From: Stas Kolenikov <skolenik@gmail.com>
>  Date: 2008/11/18
>  Subject: Re: st: Loop over variables with svyset
>  To: statalist@hsphsun2.harvard.edu
>
>
>  how about this:
>
>  * cycle over years
>  forvalues year = 1/7 {
>   * svyset for that yea
>
>  svyset [pw=weight`year']
>   * cycle over the variables
>   foreach x of varlist Q*_0`year' {
>    svy: tab `x'
>   }
>  }
>
>  You might also want to put some -quietly- and -noisily- statements in
>  places, and may be figure out more of the TeX-related Stata commands.
>  I am sure there is a way to put the tabulators & and \\ in proper
>  places from within Stata, but I've never done this with tables, only
>  with estimates using -estout-.
>
>  On 11/18/08, Daniel Schultz <schultzd@tcd.ie> wrote:
>  > Hej stata user....
>  >
>  >  Maybe this question is too easy for you, but i am kicking it around
>  >  since a week ore so and couldn't find a proper solution.
>  >
>  >  I have a dataset with 1200 variables of a survey. This survey was held
>  >  over a couple of years. What I want to do is extracting a codebook of
>  >  the dataset.
>  >  Therefore every variable should be tabbed according to their surveyweight.
>  >  The variable structure looks like this:
>  >
>  >  Q0001_02
>  >  Q0001_07
>  >  Q0002_02
>  >  Q0002_03
>  >  Q0002_07
>  >  etc.
>  >
>  >  Were the extension _0X indicates the year and the Prefix Qaaaa
>  >  indicates the question number, which is the same over the years.
>  >  Since I need the tables afterwards in an extrenal program (LaTex) all
>  >  the Variables should be proceed in the correct order.
>  >
>  >  The problem is, that not every question was asked in every year, that
>  >  I really need to change the  survey weight after every variable for
>  >  the new variable, depending on the extension. I tried a lot, but
>  >  couldn't get a proper solution.
>  >
>  >  For only one Variable the syntax should be as followed:
>  >
>  >  svyset Q1170_02   *this is the weight variable
>  >  svy:tab Q0001_02
>  >
>  >  I tried to build a loop based on this, but all my tries didn't work.
>  >  Maybe one of you has an idea. That would be great.
>  >
>
>
>  --
>  Stas Kolenikov, also found at http://stas.kolenikov.name
>  Small print: I use this email account for mailing lists only.
>
> *
>  *   For searches and help try:
>  *   http://www.stata.com/help.cgi?search
>  *   http://www.stata.com/support/statalist/faq
>  *   http://www.ats.ucla.edu/stat/stata/
>  *
>  *   For searches and help try:
>  *   http://www.stata.com/help.cgi?search
>  *   http://www.stata.com/support/statalist/faq
>  *   http://www.ats.ucla.edu/stat/stata/
>


-- 
Stas Kolenikov, also found at http://stas.kolenikov.name
Small print: I use this email account for mailing lists only.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index