st: AW: Keeping a subset of variables

["Martin Weiss" <martin.weiss1@gmx.de>]

<> 


Have you tried http://www.stata.com/support/faqs/data/regex.html ?



HTH
Martin

-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Marshall
Garland
Gesendet: Mittwoch, 4. August 2010 16:38
An: statalist@hsphsun2.harvard.edu
Betreff: st: Keeping a subset of variables

Hello-

I'm attempting to retain a subset of variables from a rather large
dataset (>10K variables). The variables have a patterned naming
convention, and I'm trying to exploit this pattern to keep only those
variables that meet specific criteria. Here's an example of some
variables:

ca003sr09d
cb004sr08d

Essentially, I only want to retain those variables that meet the
following criteria:

1. The characters in the first two positions must be "ca"
2. The numbers in the 4-5 position must be equal to 05-08
3. The numbers in the substr(var,-2,1) position must be equal to 9

I've tried to adapt code from this thread:
http://www.stata.com/statalist/archive/2008-06/msg00301.html
And this one:
http://www.stata.com/statalist/archive/2007-03/msg01034.html

But the number of conditions I'm requiring exceeds the number
encountered in these threads, which is where I'm stumbling. The code
either chokes (variable whatever cannot be found, which is expected,
hence the -cap-) or it is not eliminating the variables that I'm
expecting to be dropped, based on the admittedly inelegant syntax I've
written. I'm trying to wrap this into a single command, which is
perhaps a source of my difficulty. Here's what I've cobbled together
thus far, which has a sort of Frankensteinian character since I keep
grafting additional loops to address these conditions:

//here, i'm retaining just 5-8 grade results for all students
foreach var of varlist * {
		local beg=substr("`var'",6,2)
		local end=substr("`var'",-1,1)
	foreach letter in i p b h s e l w m f {
		foreach num of numlist 3/4 9/11 {
			cap drop c`letter'00`num'`beg'08`end'
			cap drop c`letter'0`num'`beg'08`end'
			cap drop c`letter'00`num'`beg'07`end'
			cap drop c`letter'0`num'`beg'07`end'
		}
	}
}

Any help from list members would be greatly appreciated.

I'm using Stata SE 11.1.

Cheers,

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