Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: Fwd: foreach loop for generating missing variables
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: RE: Fwd: foreach loop for generating missing variables
Date
Fri, 23 Sep 2011 15:05:50 +0100
That's a good quick solution. I am not sure that any solution not
based on brute force would be better. Here's one.
numlist "100/894"
local all `r(numlist)'
unab exist : x100-x894
local exist : subinstr local exist "x" "", all
local togen : list all - exist
foreach val of local togen {
gen x`val' = 0
}
This presupposes that x100-x894 is a valid varlist for Andreas's dataset.
Nick
On Fri, Sep 23, 2011 at 8:00 AM, Jesper Lindhardsen
<[email protected]> wrote:
> Hi Andreas
>
> This should work, although a crude method:
>
> forvalues val=100/894{
> capture gen x`val'=.
> }
>
> I must admit that I think your reason(s) for doing this should be
> re-evaluated ;-)
>
> HTH,
>
> Jesper
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of andreas chai
> Sent: 23 September 2011 03:16
> To: statalist
> Subject: st: Fwd: foreach loop for generating missing variables
>
> Dear Stata experts : PLease help!
>
> I have a series of variables "x100 ... x894" in which many of these
> variables are missing. e.g. x240 does not exist
>
> I would like to create these missing variables which contain zero for
> all
> observations.
>
> how do i create these missing variables ?
>
> i have tried writing a loop
>
> !foreach x of newlist x100- x894{
> !gen `x=92 =3D0
> !}
>
> but keep getting an error as some these variables already exist.
>
>
*
* 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/