Bookmark and Share

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: st: Keep data according to one data file's varlist


From   "Sarah Edgington" <[email protected]>
To   <[email protected]>
Subject   RE: st: Keep data according to one data file's varlist
Date   Wed, 7 Nov 2012 14:50:00 -0800

See -help ds- for info on getting the list of the variables in your data.

Are there any variables in your second data file that do not exist in the
first?  If there aren't you could do something like:

use data2, clear
ds
use data1, clear
keep `r(varlist)'

If there are variables in data2 that don't exist in data1 this example will
produce errors, but if data2 is a strict subset of the variables of the
first file it should be fine.

-Sarah

-----Original Message-----
From: [email protected] [mailto:owner-statalist@hsphsun2.
harvard.edu] On Behalf Of Zhangqunzi
Sent: Wednesday, November 07, 2012 2:25 PM
To: [email protected]
Subject: Re: st: Keep data according to one data file's varlist

Actually, I want to make the two big data sets have the same variable name
list which is from the second file. Some variables in data file 1 need to be
dropped.

I think I should creat a name list from data 2 then select the data from
data 1 according to this data 2 name list.

Can u tell me how to code in Stata?
Thanks

在 Nov 7, 2012,7:46 PM,Nick Cox <[email protected]> 写道:

> Sounds like
>
> . drop var2 var4
>
> Nick
>
> On Wed, Nov 7, 2012 at 6:41 PM, Zhangqunzi <[email protected]>
wrote:
>
>> I have two dta files, first one with variables : var 1 2 3 4 5 Second
>> one with
>> Variables: vart 1 3 5
>>
>> As their names.
>>
>> Now I would like to drop the extra variables in data file 1 which are var
2 4.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index