Luciana,
Your question seems to be how to shortcut a variable list. There are two
wildcards that I use: * and ?. ? proxies for 1 character and * for many. So
Q?00 would include Q100, Q200, QK00, etc but not QAB00. On the other hand
Q*00 would include any variable that starts with a Q and ends with 00. From
your example it would seem that an appropriate shortcut could be: Q?0?_? A
shortcut like Q* would also work, but I always like to be as restrictive as
possible so that other variables don't get included in by mistake (e.g. if
you had a variable called Quarter, it would be included in Q*)
I hope this answers your question.
~martin
-----Original Message-----
From: SURAN, LUCIANA [mailto:[email protected]]
Sent: Friday, October 17, 2003 5:16 PM
To: '[email protected]'
Subject: st: reshaping with many variables
I have a question about reshaping. I am working on a dataset containing
numerous variables, and I would like to reshape it to long form. However,
my data set has hundreds of variables and I would like to avoid typing all
the names out.
For example, my variables look like:
q100_1
q100_2
q101_1
q101_2
.
.
.
q601_1
q601_2
Does anyone know of a shortcut?
Thank you very much,
Luciana Suran
*
* 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/
*
* 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/
