Statalist


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

AW: st: Re: Re: dataset generation


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: st: Re: Re: dataset generation
Date   Tue, 21 Apr 2009 10:50:17 +0200

<> 

You want to make that last line

*************
//replace the last 10 of var5cat to missing for each of its levels
  bys var5cat: replace var4=. if _n>_N-10
*************

otherwise you would kill 22 and not 20 observations...

HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Martin Weiss
Gesendet: Dienstag, 21. April 2009 10:46
An: statalist@hsphsun2.harvard.edu
Betreff: AW: st: Re: Re: dataset generation

<> 

Here is the code, to be inserted before (or even after) the last -list-
command

*************
//drop the last 10 of var5cat for each of its levels
  bys var5cat: keep if _n<=_N-10
*************

Careful though! In Stata, you cannot "delete" a "cell", as you can in
spreadsheets. When you -drop-/-keep-, you delete entire rows, i.e.
observations. You could of course set var4 to missing, which may or may not
be closer to your notion of "deletion". 

*************
//replace the last 10 of var5cat to missing for each of its levels
  bys var5cat: replace var4=. if _n>=_N-10
*************
HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Nikolaos Pandis
Gesendet: Dienstag, 21. April 2009 10:18
An: statalist@hsphsun2.harvard.edu
Betreff: Re: st: Re: Re: dataset generation

Dear Martin,

from the last do-file that worked perfectly, how could I delete the last 10
observations from var4 at var5cat==0 and the last 10 observations from var4
at var5cat==1
--- On Mon, 4/20/09, Nikolaos Pandis <npandis@yahoo.com> wrote:


From: Nikolaos Pandis <npandis@yahoo.com>
Subject: Re: st: Re: Re: dataset generation
To: statalist@hsphsun2.harvard.edu
Date: Monday, April 20, 2009, 9:31 AM


Dear Martin,

That was great!

Thank you very much.

Nick
--- On Sun, 4/19/09, Martin Weiss <martin.weiss1@gmx.de> wrote:


From: Martin Weiss <martin.weiss1@gmx.de>
Subject: st: Re: Re: dataset generation
To: statalist@hsphsun2.harvard.edu
Date: Sunday, April 19, 2009, 7:52 PM


<>

Sorry, you said you wanted separate lb/ub for your newvars:

****
clear*
set obs 100

gen id=_n

//lower bound for var1
local a1 40
//upper bound  for var1
local  b1 100

//lower bound for var2
local a2 56
//upper bound  for var2
local  b2 76

//lower bound for var3
local a3 74
//upper bound  for var3
local  b3 88

//lower bound for var4
local a4 45
//upper bound  for var4
local  b4 67

forv i=1/4{
gen var`i'=`a`i''+int((`b`i''-`a`i''+1)*runiform())
}

gen var5cat=0
replace var5cat=1 in 51/100

list, noobs h(30)
****


HTH
Martin
_______________________
----- Original Message ----- 
From: "Martin Weiss" <martin.weiss1@gmx.de>
To: <statalist@hsphsun2.harvard.edu>
Sent: Sunday, April 19, 2009 6:47 PM
Subject: st: Re: dataset generation


><>
>
> ***
> clear*
> set obs 100
>
> gen id=_n
>
> //lower bound
> local a 40
> //upper bound
> local  b 100
>
>
> forv i=1/4{
> gen var`i'=`a'+int((`b'-`a'+1)*runiform())
> }
>
> gen var5cat=0
> replace var5cat=1 in 51/100
>
> list, noobs h(30)
> ***
>
>
> HTH
> Martin
> _______________________
> ----- Original Message ----- 
> From: "Nikolaos Pandis" <npandis@yahoo.com>
> To: <statalist@hsphsun2.harvard.edu>
> Cc: <npandis@yahoo.com>
> Sent: Sunday, April 19, 2009 6:28 PM
> Subject: st: dataset generation
>
>
>> Hi to all,
>>
>> I would like to generate 4 variables that contain  a set of integers in a

>> range from 40-100.
>> I would like to select the range per variable.
>> The total number of observations per variable would be 100.
>> Finally, I would like to create a categorical variable with 0 or 1.
>> The first 4 continuous variables, contain 50 values of category 0 and 50 
>> of category 1:
>>
>> id  var1  var2  var3 var4 var5cat
>>
>> 1   45    43     44     46    0
>> 2   43    42     48     49    0
>> .............................
>> 50   56     48    54     53    0
>>
>> 51   45    43     44    46    0
>> 52   43    42      48   49    0
>> .............................
>> 100   50     48    54     53   0
>>
>> Thank you very much.
>>
>> nick
>>
>>
>>
>> *
>> *   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/



      

*
*   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/


*
*   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   |   What's new   |   Site index