Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: RE: Fwd: foreach loop for generating missing variables


From   andreas chai <andreaschai@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Fwd: foreach loop for generating missing variables
Date   Sat, 24 Sep 2011 15:01:20 +1000

Thanks Jesper and Nick .. ! Both of your solutions work great ! your
efforts are much appreciated - that problem has been killing me all
week.

btw, Jesper, the background was that i was trying to merge two
datasets in which some variables existed in one dataset, but some only
existed in one dataset

so i needed to creat these empty variables in order to allow me to
merge and add variables together

thanks again.

cheers

andreas



On Fri, Sep 23, 2011 at 5:00 PM, Jesper Lindhardsen
<JESLIN01@geh.regionh.dk> 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: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] 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.
>
>
> thank you in advance,
> Andreas
> *
> *   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/
>

*
*   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   |   Site index