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: AW: st: AW: float to numeric??
From
"Özlen D. Luznar" <[email protected]>
To
[email protected]
Subject
Re: AW: st: AW: float to numeric??
Date
Mon, 21 Jun 2010 09:54:50 -0400 (EDT)
Hey Martin. Thanks so much for your time. I hate to take more of your
time but I really do not understand what you mean below: where you use
the inp command, can you explain what you mean there??
But note the difference that the -float()- function does make to the
> result
> here (we do not have your data, hence the example):
>
> *************
> clear*
> inp chipeligrate povcat
> 1.92 1
> 1.92 2
> 1.92 3
> 1.92 4
> 1.91 1
> 1.93 3
> end
> gen eligstatus =.
> replace eligstatus = 1 if chipeligrate ==1.92 & (povcat == 1 | povcat ==
> 2)
> replace eligstatus = 2 if chipeligrate ==1.92 & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==1.92 & (povcat == 4)
> replace eligstatus = 1 if chipeligrate ==float(1.92) & (povcat == 1 |
> povcat
> == 2)
> replace eligstatus = 2 if chipeligrate ==float(1.92) & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==float(1.92) & (povcat == 4)
> l
> *************
>
> <>
>
> " I also do not understand why float function as some recommended below
> does
> not work. Without the float. the calculation:
>
> replace eligstatus = 1 if chipeligrate ==1.92 & (povcat == 1 | povcat ==
> 2)
> replace eligstatus = 2 if chipeligrate ==1.92 & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==1.92 & (povcat == 4)
>
> will work for instance for values where povcat == 3 or povcat == 4 but
> will NOT work for obs. where povcat == 1 | 2?? returning missing values
> for those obs. for the eligstatus variable. I have no explanation for
> that. If the value is stored as float, shouldn't the calculation NOT work
> for all values??"
>
>
>
>
>
>
> But note the difference that the -float()- function does make to the
> result
> here (we do not have your data, hence the example):
>
> *************
> clear*
> inp chipeligrate povcat
> 1.92 1
> 1.92 2
> 1.92 3
> 1.92 4
> 1.91 1
> 1.93 3
> end
> gen eligstatus =.
> replace eligstatus = 1 if chipeligrate ==1.92 & (povcat == 1 | povcat ==
> 2)
> replace eligstatus = 2 if chipeligrate ==1.92 & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==1.92 & (povcat == 4)
> replace eligstatus = 1 if chipeligrate ==float(1.92) & (povcat == 1 |
> povcat
> == 2)
> replace eligstatus = 2 if chipeligrate ==float(1.92) & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==float(1.92) & (povcat == 4)
> l
> *************
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: [email protected]
> [mailto:[email protected]] Im Auftrag von Özlen D.
> Luznar
> Gesendet: Montag, 21. Juni 2010 15:06
> An: [email protected]
> Betreff: Re: st: AW: float to numeric??
>
> Hi Martin,
>
> I am really confused. I have been a stata user for some time but clearly
> I am not as strong as many of you.
>
> Please do tell, why?? this chip elig rate simply is an eligibility rate
> at the state level-- can be between 10% and 400% of the FPL hence-- .1 to
> 4 varying values. I do not neet a complicated definition. or 9 decimals
> etc.
>
> Please help me what I can do to make this variable more user friendly.
> All I need is 2 decimals. As I think some states have eligibility of 185
> % or 17% etc.
>
> I also do not understand why float function as some recommended below does
> not work. Without the float. the calculation:
>
> replace eligstatus = 1 if chipeligrate ==1.92 & (povcat == 1 | povcat ==
> 2)
> replace eligstatus = 2 if chipeligrate ==1.92 & (povcat == 3)
> replace eligstatus = 3 if chipeligrate ==1.92 & (povcat == 4)
>
> will work for instance for values where povcat == 3 or povcat == 4 but
> will NOT work for obs. where povcat == 1 | 2?? returning missing values
> for those obs. for the eligstatus variable. I have no explanation for
> that. If the value is stored as float, shouldn't the calculation NOT work
> for all values??
>
> I am still confused. I aprpeciate all your help with this.
>
> Thank you.
>
>>
>> <>
>>
>>
>> BTW, Özlen, the major distinction in Stata is between "numeric" and
>> "string"
>> variables. Within "numeric", you have data types such as integer or
>> float.
>> The "range" returned by -codebook- for your "chipeligrate" variable
>> indicates that one of its values, the minimum, is "0.1", which cannot be
>> held as integer:
>>
>> ***
>> clear*
>> inp myvar
>> 0.1
>> end
>> d
>> recast int myvar
>> ***
>>
>> If you -force- it via - recast int myvar, force-, the former "0.1" will
>> become "0". Probably not what you want...
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: [email protected]
>> [mailto:[email protected]] Im Auftrag von Özlen D.
>> Luznar
>> Gesendet: Montag, 21. Juni 2010 04:43
>> An: [email protected]
>> Betreff: st: float to numeric??
>>
>> Hi everyone,
>>
>>
>> I have a variable stored as float chip eligibility rate variable. very
>> straightforward - varies between .1 and 4. But it is stored as float
>> and
>> gives me major toruble when I am using the values to generate new
>> variables etc. I would like to store it as numeric so that stata can
>> recognize the values of this variable. Does anyone have experience with
>> this??
>> . codebook chipeligrate
>>
>>
> ----------------------------------------------------------------------------
>> --
>> chipeligrate chip eligibility rate by year and age and
>> state
>>
> ----------------------------------------------------------------------------
>> --
>>
>> type: numeric (float)
>>
>> range: [.1,4] units: .01
>> unique values: 40 missing .: 0/6585
>>
>> mean: 1.92923
>> std. dev: .720279
>>
>> percentiles: 10% 25% 50% 75%
>> 90%
>> 1 1.5 2 2
>> 3
>>
>> I need to chnage this variable and store is as int but I can not figure
>> out how. So far I tried compress but it seemed to work but when I
>> described the variable, still float.
>>
>> Thanks so much for your help in advance.
>>
>> --
>> Özlen D. Luznar
>> PhD Candidate - Public Policy
>> Graduate Research Assistant
>> University of Maryland Baltimore County (UMBC)
>> 1000 Hilltop Circle
>> Baltimore, MD 21250
>> 410-455-6527 office
>> 443-846-5010 cell
>>
>> *
>> * 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/
>>
>>
>
>
> --
> Özlen D. Luznar
> PhD Candidate - Public Policy
> Graduate Research Assistant
> University of Maryland Baltimore County (UMBC)
> 1000 Hilltop Circle
> Baltimore, MD 21250
> 410-455-6527 office
> 443-846-5010 cell
>
> *
> * 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/
>
>
--
Özlen D. Luznar
PhD Candidate - Public Policy
Graduate Research Assistant
University of Maryland Baltimore County (UMBC)
1000 Hilltop Circle
Baltimore, MD 21250
410-455-6527 office
443-846-5010 cell
*
* 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/