# RE: st: converting non-integer weights into integer weights

 From "Kieran McCaul" To Subject RE: st: converting non-integer weights into integer weights Date Thu, 20 Nov 2003 12:44:35 +0800

```gen freq=round(hhsize*w*100)

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu]On Behalf Of Ramani
> Gunatilaka
> Sent: Thursday, 20 November 2003 10:42 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: converting non-integer weights into integer weights
>
>
> Hi all,
> I am sorry to bug you with this problem again but the solution
> that Branko very kindly suggested didn't work for me.
> To recap briefly, I need to use weights with the  _pctile and
> kdensity commands. But mine are non-integer weights (for an
> example see my first mail below) and even though I multiplied the
> weights by 100 as Branko suggested (since they have only two
> decimal places) I get an error as follows:
>
>  use c:\data95\hhcons95, clear
>
> . keep x hhsize w
>
> . gen freq=hhsize*w*100
>
> . _pctile x [fweight=freq],
> percentiles(5,10,15,20,25,30,35,40,45,50,55,60,65,7
> > 0,75,80,85,90,95,99)
>
> may not use noninteger frequency weights
> r(401);
>
> I have a hunch that multiplying the original weight by 100 made
> it too long to be stored as an integer. The largest transformed
> weight then becomes 7 digits.
>
> Would anybody have any ideas on this?
>
> Thanks so much,
> Ramani
>
>
>
> Bmilanovic@worldbank.org wrote:
> >       Ramani,
> >
> > why don;t you multiply the weights by a hundred (or whatever; a
> > thousand),
> > and then create integers. kdensity should  work then.
> >
> >       best, branko
> >
> >
> >
> >
> >    IMPORTANTISSIMO!!!
> >    From around October 15, 2003 my new
> >    Email address will be
> >    bmilanovic@ceip.org
> >
> >
> >    ALL ABOUT INEQUALITY IN THE WORLD (AND MORE!)
> >    http://www.worldbank.org/research/inequality/
> >
> >
> >
> >
> >
> > Ramani Gunatilaka
> > <Ramani.Gunatilaka@buseco.mon To:
> > ash.edu.au> Statalist@Hsphsun2.Harvard.Edu
> > Sent by: cc:
> > owner-statalist@hsphsun2.harv Subject: st: Use of Weights in Kernel
> > Density Estimation
> > ard.edu
> >
> >
> > 11/16/2003 09:11 AM
> > Please respond to statalist
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi all,
> > I hope there maybe someone out there who may be able to help me
> with this
> > query.
> > I have a household level data set of roughly 19,000 households with the
> > following variables: per capita consumption in rupees (x), population
> > weights
> > (w) and household size (hhsize) as in the sample below (I'm sorry the
> > column
> > heads are not aligned).
> >
> > x            w           hhsize
> > 204.4059           176.45            3
> > 402.0174           119.22            6
> > 218.7155           51.84             8
> > 1083.199           1266.73           6
> > 303.6877           169.54            3
> >
> > The weights represent the number of households in the entire population
> > that
> > each particular household represents.
> >
> > I need to estimate the kernel density of the consumption
> distribution and
> > have
> > consulted Stata's kdensity function as well as the akdensity module
> > developed by
> > Van Kerm. Both permit the use of weights, but only of fweights and
> > aweights. But
> > while the weights in my data set are frequency weights, they are
> > certainly not
> > integers as required by Stata.
> >
> > Would someone know how I may get round this problem? I'd rather use the
> > kdensity
> > or akdensity commands and not have to write up a programme from scratch.
> >
> > Thanks so much,
> > Ramani
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/support/faqs/res/findit.html
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> >
> >
> >
> >
> >
> >
> > *
> > *   For searches and help try:
> > *   http://www.stata.com/support/faqs/res/findit.html
> > *   http://www.stata.com/support/statalist/faq
> > *   http://www.ats.ucla.edu/stat/stata/
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
>

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```