Statalist The Stata Listserver


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

Re: st: Dropping Subset of Variables


From   "Gauri Khanna" <gwkhanna@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Dropping Subset of Variables
Date   Thu, 29 Mar 2007 12:18:12 +0000

Dear Neil,

I tried out the command but I get an error of invalid syntax


forval x in 1/6{
2. drop hvidx_0`x'
3. }
invalid syntax
r(198);

I have just expanded a bit more the dataset so that it is clearer. I would like to drop variabeles with hv*_02 to hv*_46. Thank you for your time.

hvidx_01 byte %8.0g line number
hv101_01 byte %8.0g hv101_01 relationship to head
hv102_01 byte %8.0g hv102_01 usual resident
hv103_01 byte %8.0g hv103_01 slept last night
hv104_01 byte %8.0g hv104_01 sex of household
....
hvidx_02 byte %8.0g line number
hv101_02 byte %8.0g hv101_02 relationship to head
hv102_02 byte %8.0g hv102_02 usual resident
hv103_02 byte %8.0g hv103_02 slept last night
hv104_02 byte %8.0g hv104_02 sex of household member
...
hvidx_21 byte %8.0g line number
hv101_21 byte %8.0g hv101_21 relationship to head
hv102_21 byte %8.0g hv102_21 usual resident
hv103_21 byte %8.0g hv103_21 slept last night
hv104_21 byte %8.0g hv104_21 sex of household member
...
hvidx_46 byte %8.0g line number
hv101_46 byte %8.0g hv101_46 relationship to head
hv102_46 byte %8.0g hv102_46 usual resident
hv103_46 byte %8.0g hv103_46 slept last night
hv104_46 byte %8.0g hv104_46 sex of household member
hv105_46 byte %8.0g hv105_46 age of household members
hv106_46 byte %8.0g hv106_46 highest educational level
....
idxh4_01 byte %8.0g index to household schedule
sh09_01 byte %8.0g sh09_01 marital status
sh11_01 byte %8.0g sh11_01 can read and write
sh12_01 byte %8.0g sh12_01 ever been to school
sh13_01 byte %8.0g sh13_01 main reason never went to school
sh14_01 byte %8.0g highest grade
...
idxh4_12 byte %8.0g index to household schedule
sh09_12 byte %8.0g sh09_12 marital status
sh11_12 byte %8.0g sh11_12 can read and write
sh12_12 byte %8.0g sh12_12 ever been to school
sh13_12 byte %8.0g sh13_12 main reason never went to school
sh14_12 byte %8.0g highest grade


Regards,

Gauri




From: "Gauri Khanna" <gwkhanna@hotmail.com>
Reply-To: statalist@hsphsun2.harvard.edu
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: Dropping Subset of Variables
Date: Thu, 29 Mar 2007 12:06:25 +0000

Dear Neil,


I will try out your command that you sent.


As an explanation (and sorry for not being clear): I use the -describe- command below. As you see, I have a bunch of variables (I have copied a subset from my data set as an example ). I am interested in getting rid of variables with _02 to _46 in the first set with hv* characters (hence hvidx_02, h101_02 etc . uptil _46). I also have more variables (also shown below) that share the same suffix _01,_02 .... which I woud like to keep. Hence, my question is how can I get rid of the variabeles with hv*_02 to hv*_46.


hvidx_01 byte %8.0g line number
hv101_01 byte %8.0g hv101_01 relationship to head
hv102_01 byte %8.0g hv102_01 usual resident
hv103_01 byte %8.0g hv103_01 slept last night
hv104_01 byte %8.0g hv104_01 sex of household member
hv105_01 byte %8.0g hv105_01 age of household members
hv106_01 byte %8.0g hv106_01 highest educational level
hv107_01 byte %8.0g hv107_01 highest year of education
hv108_01 byte %8.0g hv108_01 education in single years
hv109_01 byte %8.0g hv109_01 educational attainment
hv110_01 byte %8.0g hv110_01 member still in school
hv115_01 byte %8.0g hv115_01 current marital status
hv116_01 byte %8.0g hv116_01 currently, formerly, never m.
hv117_01 byte %8.0g hv117_01 eligibility for female intview
hvidx_02 byte %8.0g line number
hv101_02 byte %8.0g hv101_02 relationship to head
hv102_02 byte %8.0g hv102_02 usual resident
hv103_02 byte %8.0g hv103_02 slept last night
hv104_02 byte %8.0g hv104_02 sex of household member
hv105_02 byte %8.0g hv105_02 age of household members
hv106_02 byte %8.0g hv106_02 highest educational level
hv107_02 byte %8.0g hv107_02 highest year of education
hv108_02 byte %8.0g hv108_02 education in single years
hv109_02 byte %8.0g hv109_02 educational attainment
hv110_02 byte %8.0g hv110_02 member still in school
hv115_02 byte %8.0g hv115_02 current marital status
hv116_02 byte %8.0g hv116_02 currently, formerly, never m.
hv117_02 byte %8.0g hv117_02 eligibility for female intview
hvidx_03 byte %8.0g line number
hv101_03 byte %8.0g hv101_03 relationship to head
hv102_03 byte %8.0g hv102_03 usual resident
hv103_03 byte %8.0g hv103_03 slept last night
hv104_03 byte %8.0g hv104_03 sex of household member
hv105_03 byte %8.0g hv105_03 age of household members
hv106_03 byte %8.0g hv106_03 highest educational level
hv107_03 byte %8.0g hv107_03 highest year of education
hv108_03 byte %8.0g hv108_03 education in single years
hv109_03 byte %8.0g hv109_03 educational attainment
hv110_03 byte %8.0g hv110_03 member still in school
hv115_03 byte %8.0g hv115_03 current marital status
hv116_03 byte %8.0g hv116_03 currently, formerly, never m.
.
..
....
idxh4_01 byte %8.0g index to household schedule
sh09_01 byte %8.0g sh09_01 marital status
sh11_01 byte %8.0g sh11_01 can read and write
sh12_01 byte %8.0g sh12_01 ever been to school
sh13_01 byte %8.0g sh13_01 main reason never went to school
sh14_01 byte %8.0g highest grade
sh16_01 byte %8.0g sh16_01 main reason not going to school
sh17_01 byte %8.0g sh17_01 occupation
sh18_01 byte %8.0g sh18_01 work for salary
sh24_01 byte %8.0g sh24_01 chew tobacco
sh25_01 byte %8.0g sh25_01 drink alcohol
sh26_01 byte %8.0g sh26_01 smoke
sh27_01 byte %8.0g sh27_01 smoked regularly
shed4_01 byte %8.0g shed4_01 education
shed6_01 byte %8.0g shed6_01 education
shage_01 byte %8.0g age of hh members or from
woman's questionnaire
idxh4_02 byte %8.0g index to household schedule
sh09_02 byte %8.0g sh09_02 marital status
sh11_02 byte %8.0g sh11_02 can read and write
sh12_02 byte %8.0g sh12_02 ever been to school
sh13_02 byte %8.0g sh13_02 main reason never went to school
sh14_02 byte %8.0g highest grade
sh16_02 byte %8.0g sh16_02 main reason not going to school
sh17_02 byte %8.0g sh17_02 occupation
sh18_02 byte %8.0g sh18_02 work for salary
sh24_02 byte %8.0g sh24_02 chew tobacco
sh25_02 byte %8.0g sh25_02 drink alcohol
sh26_02 byte %8.0g sh26_02 smoke
sh27_02 byte %8.0g sh27_02 smoked regularly


Regards,

Gauri


From: "Neil Shephard" <nshephard@gmail.com>
Reply-To: statalist@hsphsun2.harvard.edu
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: Dropping Subset of Variables
Date: Thu, 29 Mar 2007 11:13:30 +0100

On 3/29/07, Gauri Khanna <gwkhanna@hotmail.com> wrote:

Unfortunately, the wild card does not help because I have other variables in
my data set that have _02, _03 etc. attached and which I may want to keep.
I want to try and get rid of these listed variabls only with the _02 to _46
suffix.
I don't see what your trying to do, to start with you are saying you
have other variables with _02..._46 that you want to keep, and then
you say you want to get rid of variables only with the _02..._46
suffix.  This seems contradictory to me.

You can use the wild-card * in the middle so if you have...
. des
hvidx_01
hvidx_02
hvidx_03
hvidx_04
hvidx_05
hvidx_06
hv101_01
hv101_02
hv101_03
hv101_04
hv101_05
hv101_06
hv102_01
hv102_02
hv102_03
hv102_04
hv102_05
hv102_06

and you wanted to get rid of the hvidx_02 to hvidx_06 but retain all
of the hv101* and hv102 variables then you could use something like..

forval x in 1/6{
 drop hvidx_0`x'
}

Could you provide a clearer example of what you want to achieve.

The output from -describe- which will list the variable names, and
then say which you want to remove from the dataset.

Neil
--
"Every great advance in natural knowledge has involved the absolute
rejection of authority."  - Thomas H. Huxley

Email - nshephard@gmail.com / n.shephard@sheffield.ac.uk
Website - http://slack.ser.man.ac.uk/
Photos - http://www.flickr.com/photos/slackline/
*
*   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/
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

*
* 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/
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index