Yang wrote:
I am currently working on project where I need to use multiple datasets (i
do not have access to the original data) on a server.
Each dataset is a country and I am interested in variables X1,X2,X3, Y
How do I run a regression ACROSS the countries with the dependent variable
Y and explanatory variables X1,X2,X3 given that I have multiple datasets
that I cannot merge? do I do a looping function?
But X1,X2 are defined slightly different in each of the country's
datasets, so is there a way to both loop through the countries and
redefine each country's variable when I am at it?
------------------------------------------------
Question:
Is it a technical or legal constraint that forbids you to open a dataset with Stata and next save a copy of it on your own computer?
That seems to be neccesary to perform what you want. For each country:
1. Open the dataset from the server.
2. -keep- the variables you need.
3. -save- the reduced dataset to your own computer
4. modify the X1,X2 variables to conform the same rules for all countries
Finally, -append- the modified datasets.
Hope this helps,
Svend
________________________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone, work: +45 8942 6090
Phone, home: +45 8693 7796
Fax: +45 8613 1580
E-mail: [email protected]
_________________________________________________________
*
* 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/
