# Re: st: Loop over variables with svyset

 From "Daniel Schultz" To statalist@hsphsun2.harvard.edu Subject Re: st: Loop over variables with svyset Date Wed, 19 Nov 2008 10:35:20 +0000

```Hej Stas....

this seemed to be a nice idea.....
BUT....
For this kind of loop I need again for every variable every year. But
unfortunately I don't have Variables for every year. Often only for
the year 2002 and 2007, but also 2004 and 2006...you see what I mean?
That is the biggest problem with this kind of loop. I think I have to
split the data set even if this means more manually work.

Best
Daniel

2008/11/18 Stas Kolenikov <skolenik@gmail.com>:
> 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.
>>  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
>>
>>
>>
>>  * 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/
>
>
*
*   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/
```