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 <[email protected]> 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 <[email protected]>
> Date: 2008/11/18
> Subject: Re: st: Loop over variables with svyset
> To: [email protected]
>
>
> 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 <[email protected]> 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/
