Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: RE: Modify large data base without opening it


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: Modify large data base without opening it
Date   Wed, 24 Sep 2008 23:17:41 +0200

Been there myself:
http://www.stata.com/statalist/archive/2008-04/msg01278.html

-drop-ping probably requires the data to be held in memory, so unless you
can open the dataset... Still, my initial post remains valid: -use- whatever
you want to -keep- in terms of variables, and -save- under a different name
and you have effectively -drop-ped, right?

HTH
Martin


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of José Luis Chávez
Calva
Sent: Wednesday, September 24, 2008 11:10 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: RE: Modify large data base without opening it

Thanks for the quick response. I apologize for not making myself
clear: I want to drop the variables because I'm trying to clean the
data set. That's why I would like to know if there is a command to
drop them without opening the data set.
Thanks again,
José Luis

2008/9/24 Michael I. Lichter <mlichter@buffalo.edu>:
> Martin is of course right and I apologize for misreading the question. I
was
> thinking about my own problems with reading large datasets not yet in
Stata
> format.
>
> -ml
>
> Martin Weiss wrote:
>>
>> No need to drop anything, just load whatever you need with -use with
>> options-. See - h use-
>>
>>
>> HTH
>> Martin
>>
>>
>> -----Original Message-----
>> From: owner-statalist@hsphsun2.harvard.edu
>> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of José Luis
>> Chávez
>> Calva
>> Sent: Wednesday, September 24, 2008 10:18 PM
>> To: statalist@hsphsun2.harvard.edu
>> Subject: st: Modify large data base without opening it
>>
>> I'm working with a very large data base (1000m, 2000 vars) and my PC
>> is taking too long to open it. I would like to know if there is a way
>> or a specific command to drop some variables without actually opening
>> the data base.
>>
>> Thanks in advance,
>>
>> José Luis Chávez Calva
>>
>> *
>> *   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/
>>
>
> --
> Michael I. Lichter, Ph.D.
> Research Assistant Professor & NRSA Fellow
> UB Department of Family Medicine / Primary Care Research Institute
> UB Clinical Center, 462 Grider Street, Buffalo, NY 14215
> Office: CC 125 / Phone: 716-898-4751 / E-Mail: mlichter@buffalo.edu
>
> *
> *   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