Stata project jobs

Research Assistant for a Research Project Project Duration: [ 3 months] Overview: We are seeking a highly skilled and motivated Research Assistant to support a significant research project led by a University. The ideal candidate will possess a strong background in financial databases, data analysis, and academic research, with proven expertise in using Stata for data organization and analysis. Responsibilities: Download and extract data from financial databases and annual reports as well as others as required. Efficiently merge and manage datasets from multiple sources to ensure consistency and accuracy. Conduct thorough literature reviews in finance and related fields to support research objectives. Utilize Stata to analyze complex datasets, perform...

I am in need of an expert in Stata who can help me generate specific numeric variables using logical conditions. The new variables will be created based on the existing data in my dataset, and the conditions will need to be carefully defined. Ideal Skills and Experience: - Proficiency in Stata, particularly in variable creation and manipulation. - Strong understanding of logical conditions and how to apply them in Stata. - Experience with data analysis and manipulation is a plus. Here is the project: I am looking to create new variables in a monadic dataset using information from a dyadic dataset. This will most likely require appending a dataset. I have a dataset that is monadic (one observation for a country per year) in which they make an alliance. There ...

As the project leader, I'm searching for a knowledgeable data analyst who exhibits expertise in descriptive, inferential, and predictive modeling techniques. Proficiency in Stata will be essential for this project, as we have specific tasks that need skilled attention. Main Tasks: - Engaging in sophisticated statistical analysis using Stata. Overall, our project will achieve three primary objectives: 1. Testing and confirming a set of hypotheses. 2. Unveiling patter within our extensive set of data. 3. Utilizing these patterns to make authentic, data-based predictions. Essential Skills and Experience: - A firm grasp of descriptive and inferential statistics. - Strong predictive modeling skills. - Expert proficiency in conducting statistical ana...

I'm working on my university economics project requiring assistance with econometrical modeling in Stata. Specifically, I need help applying a linear regression model. The ideal freelancer for this job is highly proficient in Stata with extensive experience in econometrics. Key requirements include: - Expertise in using Stata for econometrics analysis. - Good knowledge and understanding of economics, specifically in creating and applying linear regression models. - Ability to instruct me on the steps taken to provide an understanding of how to utilize these skills in the future.

I'm urgently seeking a skilled STATA specialist to assist me in an Econometric modeling project. Attached are the assessment details.

I'm in need of a proficient Stata expert who can assist me in multiple aspects of my project. Key Tasks: 1. Statistical Analysis and Modeling: This will form the heart of your duties. They would involve all aspects, from Regression Analysis, Time Series Analysis to Factor Analysis. Experience in all these aspects is mandatory. Goals: 1. Predictive modelling: We should be able to make accurate and reliable future projections from our data. 2. Exploratory data analysis: Uncover the underlying patterns and understand the structures within our data. 3. Hypothesis testing: Finally, test the assumptions we've gathered from our data. Experience in working with statistical analysis software, STATA, is essential for this project. Additionally, a background...

I have a project that involves conducting a thorough data analysis using Stata. The main objective of this data analysis is to explore data patterns, generate statistical insights, and predict future trends. - The data I have is a mix of numeric, categorical, and textual data. I'm looking for a seasoned data analyst with a deep understanding of Stata, who can engage with the data and provide a comprehensive analysis. The project is time-sensitive, so I need someone who can deliver high-quality work within a short timeframe.

...and data analyst proficient in Stata software to execute comprehensive data analysis for me. Key Tasks: - Conducting descriptive statistics, hypothesis testing, and regression analysis on a sizable dataset. - Ensuring that the analysis is thorough, accurate, and adequately covers all variables in the dataset. Specifics: - The dataset is quite large, requiring meticulous handling, especially in terms of time taken for the analysis. - There are a significant number of variables, which implies a considerable volume of data to process. Ideal Candidate: - Must be a Stata expert with proven experience in handling extensive data analysis. - Statistician background is beneficial, as a thorough understanding of statistical tests is required. This is a crucial project fo...

My project requires a professional with expertise in econometrics, specifically regression analysis, using Stata software. It also calls for the delivery of a comprehensive report based on the analysis findings. Key Skills and Experience: - Proficiency in econometrics, particularly regression analysis - Demonstrable experience using Stata for data analysis - Ability to translate analysis results into a detailed, coherent report

I'm in need of a data...will be experienced in Excel, STATA, and SPSS as well. The main tasks include performing data analysis, creating engaging data visualisations, and building data models. Key Responsibilities: - Performing thorough data analysis using tools like STATA, SPSS, and Excel - Proficient in R for creating engaging data visualisations - Building data models to support the provided data Ideal Skills and Experience: - Proven experience in data analysis - Expertise in R and other relevant tools like Excel, STATA, and SPSS - Ability to create engaging data visualisations, preferably in the form of stacked bar charts - Strong understanding of data models and related concepts If you have the necessary skills and experience, I'd be very interested i...

I'm seeking a skilled economist to help me ...comprehensive report on the topic of Economic growth and development in the realm of Development Economics. Key tasks for the project include: - Conducting in-depth research on the topic of Economic growth and development. - Using Stata to analyze data. - Providing a detailed discussion of the subject matter. Please bear in mind that the report is to be a detailed and thorough exploration of Economic growth and development. The report should not only cover the theoretical aspects of the topic but also the practical application of these theories. Ideal skills and experience for this job include: - Strong background in Economics and Development Economics. - Proficiency in using Stata for data analysis. - Excellent...

I'm in need of a comprehensive Stata expert to delve deep into a financial dataset and compile an insightful, actionable report based on the findings. The main objective here is to provide a detailed discussion on the trends and patterns identified within the financial data, alongside some data-driven recommendations. Key responsibilities: - Exploring and identifying trends, patterns, and anomalies in the financial dataset using Stata - Compiling a detailed report that covers the above, with a particular focus on generating actionable insights - Ensuring the report has a clear, concise and professional structure and presentation Ideal candidate should have: - Proficiency in Stata and prior experience with financial data analysis - Strong analytical skills and t...

I'm in need of a seasoned biostatistician who is adept at using SPSS/SAS for a project that involves hypothesis testing. - The project involves hypothesis testing specifically; an understanding of the associated statistical techniques is essential. - Proficiency in SPSS/SAS/R/Stata is a must. - A background in biostatistics is highly preferable. - Experience in the medical or clinical data analysis field is a big plus. - Attention to detail, accuracy, and ability to communicate findings in a clear, concise manner is crucial. Please bid if you're confident in your ability to deliver quality work in this domain.

I have a dataset consisting of numeric data from online surveys that I need to be entered into STATA. This would require data cleaning and preprocessing before entry. Key Responsibilities: - Entering numeric data from online surveys into STATA. - Cleaning and preprocessing the data to ensure its quality and accuracy. Ideal Skills and Experience: - Proficiency in STATA. - Prior experience in data entry and cleaning. - Understanding of data preprocessing techniques. - Attention to detail to maintain data accuracy. - Ability to work with numeric data.

I'm seeking a knowledgeable statistician who can assist in medical research, focusing primarily on disease prevalence assessment. This statistician will be working with both continuous and categ...and categorical variables within a dataset of less than 100 samples. Key Responsibilities: - Expert analyses of complex medical data - Application of appropriate statistical methodologies Ideal Skills and Experience: - Proficient in statistical software (e.g., SPSS, Stata, R) - Experience with medical research - Understanding of disease prevalence studies - Comfortable working with small datasets - Strong grasp of both continuous and categorical variables Your expertise is vital in advancing this medical research project. If you possess the skills and have a passion for...

This project seeks a highly qualified professional with extensive experience in econometrics and statistical regression modeling, particularly utilizing STATA software. The project involves a comprehensive analysis of employee wage data using quantile regression and decomposition techniques, both with sample selection adjustments. OBJECTIVE 1.) Determine the impact of various characteristics of workers on their wage in the Sectors (regular and casual separately) using the BEST sample selection adjustment technique along a conditional quantile regression model, and then decompose the gender wage gap (between males and females) with the same sample selection adjustment technique using Melly’s Machado-Mata decomposition for regular and casual separately. 2.) Dete...

For my project, I require the expert knowledge of an Econometrics professional who is adept at operating the STATA software. The primary task centers on the analysis of cross-sectional data. This endeavor will necessitate the utilisation of descriptive statistics. It would favor the project greatly if the chosen freelancer has experience in executing similar tasks and possesses a firm understanding of hypothesis testing and regression analysis. Skills and Experience: - Proficient in Econometrics - Expert user of STATA - Strong experience in data analysis - Solid background in descriptive statistics - Familiarity with cross-sectional data analysis. A freelancer who exhibits these skills and has a history of efficient task completion will be the ideal fit.

I'm launching a project in the medicinal field and am in need of a competent and dedicated research assistant. You'll primarily be dealing with published literature and are expected to perform the following tasks: • Assist in literature reviews in a research topic • Screen search results ibased on a predefined criteria to select studies for inclusion in the review. • Extract data from selected studies using standardized forms and protocols. • Verify the accuracy and completeness of extracted data, resolving discrepancies through discussion with team members. • Summarize and synthesize findings from included studies, highlighting key results and trends. • Participate in team meetings, providing updates on progress, challenges, and insights gain...

I would like you to scrape the website uitspraken.rechtspraak.nl. This is a website in Dutch with all data from Dutch court cases. T...the facts would do. I am not sure if all of them have this, though. 8. Deliver both the data and the scripts or software necessary to run it. I want to be able to run the script independently later on. DELIVER THE SCRIPT(S) IN SUCH A WAY THAT I CAN LATER EASILY SCRAPE ONLY CASES THAT WERE ADDED AFTER A GIVEN DATE. As to the data set: I would prefer to receive a data set that is (readable into) Stata format. Other formats that are easily readable on a Windows pc are ok too, as long as they facilitate the large pieces of text that "Uitspraak" will deliver. If you have any further questions, please let me know before you bid. PS I need deli...

This project seeks a highly qualified professional with extensive experience in econometrics and statistical regression modeling, particularly utilizing STATA software. The project involves a comprehensive analysis of employee wage data using quantile regression and decomposition techniques, both with sample selection adjustments. OBJECTIVE 1.) Determine the impact of various characteristics of workers on their wage in the Sectors (regular and casual separately) using the BEST sample selection adjustment technique along a conditional quantile regression model, and then decompose the gender wage gap (between males and females) with the same sample selection adjustment technique using Melly’s Machado-Mata decomposition for regular and casual separately. 2.) Dete...

...experienced professional to assist with various Stata and Economics project about the effect of Covid-19 on parental labour force outcome. You’ll be responsible for data analysis, statistical modeling, and data interpretation. These tasks are crucial to achieving the project's unstated objectives. Key Responsibilities: - Conduct comprehensive data analysis - Create insightful statistical models - Interpret complex data Skills & Experience: - Proficient in Stata - Extensive Economics background - Strong analytical skills - Excellent forecasting abilities - Efficient in data visualization and policy analysis As part of your application, please include examples of past work and any relevant experience relating to this project. Detailed proj...

I would like you to scrape the website uitspraken.rechtspraak.nl. This is a website in Dutch with all data from Dutch court cases. T...the facts would do. I am not sure if all of them have this, though. 8. Deliver both the data and the scripts or software necessary to run it. I want to be able to run the script independently later on. DELIVER THE SCRIPT(S) IN SUCH A WAY THAT I CAN LATER EASILY SCRAPE ONLY CASES THAT WERE ADDED AFTER A GIVEN DATE. As to the data set: I would prefer to receive a data set that is (readable into) Stata format. Other formats that are easily readable on a Windows pc are ok too, as long as they facilitate the large pieces of text that "Uitspraak" will deliver. If you have any further questions, please let me know before you bid. PS I need deli...

I have conducted Multinomial logit regression. I'm looking for someone who can interpret the results of the marginal effects of the multinomial regression (write-up of around 500-800 words). The analysis is related to finding the factors that affect the outcome of cricket mat...Dependent variable is match outcome which is a categorical variable which can take value of draw/ home team win/ home team lose. The ideal candidate would have a strong background in economics and statistical analysis, specifically: - An understanding of econometrics - The ability to interpret results - Familiarity with Multinomical Logit in Stata Your main task will be to provide insights and understanding from the analysis. This project requires immediate attention, so a prompt response...

I need an experienced statistician to conduct a Difference in Differences (DiD) analysis using STATA software on two differential datasets. The task involves a comparative study of two separate 'intervention groups' made up of 2 and 3 geographies, respectively, against a 'non-intervention' group of 6 geographies. KEY REQUIREMENTS: • STATA proficiency: Proficiency in STATA (any version) is required for this project. • DiD Analysis: Expertise in DiD analysis is crucial, with an emphasis on analyzing the 'Treatment effect'. • Measurement Metrics: Knowledge in measuring treatment effects is important, particularly in intervention-related differences across 12 unique variables or indices. This intricate task comes wi...

This project seeks a highly qualified professional with extensive experience in econometrics and statistical regression modeling (specifically Quantile Regression-QR), particularly utilizing STATA software. The project involves a comprehensive analysis of employee wage data using quantile regression and decomposition techniques. OBJECTIVE Determine the impact of various worker characteristics on their wage in the Sectors (regular and casual separately) using centred regression for different percentiles. Then, the gender wage gap (between males and females) will be decomposed using Oaxaca-Blinder Decomposition (or Machado-Mata-Melly Decomposition) using this centred regression coefficient for different percentiles for regular and casual sectors separately. Centred Re...

I need a freelancer proficient with STATA, particularly in managing and manipulating panel data for rigorous analysis. Your role will involve: - Cleaning and preparatory tasks to ready the dataset for ensemble. - Performing meticulous panel data analysis to reveal causal relationships or impact. I have my own panel data available for this project. It would be ideal if you have solid experience in data visualization and can translate complex models into easily understandable results. Your ability to discern and illustrate causal relationships and impacts from the data would be an unparalleled advantage in this project. Your STATA proficiency and analytical skills should be topnotch identifying key insights from the data.

This project seeks a highly qualified professional with extensive experience in econometrics and statistical regression modeling, particularly utilizing STATA software (as an alternate, R/RStudio can also be used). The project involves a comprehensive analysis of employee wage data using quantile regression and decomposition techniques. OBJECTIVE Determine the impact of various characteristics of workers on their wage in the Sectors (regular and casual separately) using the BEST sample selection adjustment technique along a conditional quantile regression model, and then decompose the gender wage gap (between males and females) with the same sample selection adjustment technique using Melly’s Machado-Mata Decomposition for regular and casual separately. WORK EX...

• You should undertake an empirical exploration of the chosen topic, using databases/sources recommended below or any other widely available and recognised datasets. Such sources are government agencies, international and national organisations, widely recognised institutions that specialise in relevant areas.

I am looking to create new variables in a monadic dataset using information from a dyadic dataset. This will most likely require appending a dataset. I have a dataset that is monadic (one observation for a country per year) in which they make an alliance. There is another accompanying dataset that has the same information but with a list of each member of the alliance. I need to know if a state that makes an alliance but reneges on the alliance has a harder time making an alliance with one of its prior alliance members in the future.

This project seeks a highly qualified professional with extensive experience in econometrics and statistical regression modeling, particularly utilizing STATA software (as an alternate, R/RStudio can also be used). The project involves a comprehensive analysis of employee wage data using quantile regression and decomposition techniques. Objectives: 1. Sample Selection Corrected Conditional Quantile Regression & Decompositions: - Evaluate the impact of various employee characteristics on their wages across different employment types, employing sample selection correction for conditional quantile regression. - Decompose the gender wage gap using a Sample Selection Adjusted conditional quantile regression with Melly's Machado-Mata Decomposition. 2. Unco...

I'm seeking a capable professional with extensive experience in econometrics and statistical regression modeling using R or STATA software who can conduct a thorough analysis of my given dataset by applying different types of quantile regression modelling and decomposition analysis to a secondary dataset of employees and their wages. The work to be done is mainly by following the research methodologies outlined in some research papers, which I will be providing myself. The objectives of the study are as follows: 1.) Determine the impact of various characteristics of workers on their wage in the different type of employment using “sample selection correction for conditional quantile regression” and then decompose the gender wage gap (between males and females) with...

For my project, I require a skilled Biostatistician to conduct in-depth statistical analysis. Key Requirements: - I need you to teach me all the procedure what you have done and explain me every thing. - The analysis needs to encompass both Descriptive and Inferential statistics. This will help shape insights hidden within the data. - Our data set is quite varied and contains more than ten different variables or factors. Therefore, a broad analytical understanding will be needed. - Crucially, our data is sourced from Public Databases. The freelancer should have experience dealing with this kind of data and be aware of any associated challenges. Ideal skills and experience: - Experience in biostatistics and data analysis from public databases. - Adept with descriptive and in...

I need an expert fluent in Stata to perform a comprehensive linear regression analysis for my project. Professionals in this area will be manipulating between two to five independent variables. The scope includes: 1. Identifying trends and patterns 2. Analyzing variable impact 3. Building data models Ideal skills would be: • Proficient in Stata • Strong experience in linear regression analysis • Understanding of multi-variable dynamics

I have done the majority of the code and need final bits done. I'm in need of a freelancer with solid experience in statistical analysis, specifically focused on hypothesis testing and regression analysis. This project requires analysis of 5-10 variables, indicating a nuanced understanding of how these variables interact. The analysis needs to be conducted in Stata, so proficiency in this software is non-negotiable. **Ideal Skills and Experience:** - Proficient in Stata - Experienced in hypothesis testing - Skilled in regression analysis involving 5-10 variables - Strong analytical and problem-solving skills - Ability to interpret data and provide meaningful conclusions - Excellent communication skills to explain complex statistical concepts in understandable ter...

I require comprehensive assistance in analysing my time series data through Stata software. - The project entails data analysis, programming assistance, and statistical modelling. - The data to be analyzed is time series in nature. Your role will include cleaning, organizing, and analysis of this data. - Ultimately, the aim is to conduct an in-depth trend analysis from the time series data. The ideal candidate must have: - Familiarity and experience with Stata software. - Significant experience in time series data analysis. - A robust understanding of statistical modelling techniques. - Proven skills in programming particularly suited for statistical analysis. Your ability to present trend analysis results in a clear, easy-to-understand format is also important. Pl...

I am seeking an experienced freelancer to perform an econometric analysis using panel data. The study is on the impact of general economic conditions on the performance of equity REITs. The project is a 4 page report with the following sub-parts: I. Reference Paper a. Suitability of Methodological Reference b. Paper Review II. Data a. Identification and Description b. Basic Summary Statistics III. Model Specification and Setup a. Variable Selection b. Econometric Model c. Limitations d. Preliminary baseline results Please reach out for more details!

I'm seeking an experienced data analyst proficient in Stata to assist in a predictive analysis project. The ideal candidate will conduct a group-based trajectory analysis on a set of survey data with the following goals: 1. Make accurate predictions and forecasts based on the available data. 2. Identify underlying risk factors within the analyzed groups. Must-have Qualifications: - Advanced Stata proficiency - Strong background in statistical analysis - Experience with group-based trajectory modeling - Prior work analyzing survey data Responsibilities: - Clean and prepare the survey data set for analysis. - Apply group-based trajectory methods to identify patterns. - Communicate insights and identify potential risk factors. - Provide a comprehensive report deta...

I'm seeking a skilled individual for consultation and assistance in a critical review project. Having a project predicated on meticulous research, I expect comprehensive work underpinned by proven methods. Key Project Aspects: - Focusing on medical studies - Utilizing peer-reviewed journals - Prioritizing specific patient populations - Concentrating on distinct interventions Ideal Skills: - Expertise in meta-analysis methodologies namely CMA - Proficiency with statistical software (e.g., R, Stata) - Background in medical research or health sciences - Adept at systematic reviews and evidence synthesis - Familiarity with PRISMA guidelines - Critical thinking for quality assessment - Detail-oriented for precise inclusion/exclusion criteria I'm eager ...

Create a dataset containing all information from all titles released between 1930 and 1980 from the following URL ,asc&ref_=kw_ref_key The search produces a long list. I need the information provided by t...miss: • Movie-TV tag (for example, TV episode, podcast, short film, ….TV series…TV short). • Genres • Keywords • IMDb Rating • Release year (and end year if available). • Show description. • Storyline. • Details tab: all information available, including release date, country of origin, Language, Filming locations, and production companies (this is essential). The output dataset can be CSV or Stata file(s). Please let me know how you plan to tackle this task and an estimate of how long it will take you.

I am working on an exciting but challenging project: my Master's thesis in Science. This advanced research paper requires a keen analytical mind and a strong background in business and analysis methodologies. Here’s what I am looking for in a freelancer: - Proficient in Quantitative Research: You should possess a solid understanding of data-driven research methods. - Statistical Analysis Guru: Expertise in statistical tools and software is essential. You should be able to dissect complex data sets effortlessly. - Data Interpretation Skills: I need someone who can translate raw data into meaningful conclusions and insights. - Academic Writing Excellence: Your writing should be clear, concise, and formatted appropriately for academic submissions. - Attention to Detail: A...

The model consists of six explanatory variables, two of which are dummy variables, and another two are control variables for the period 2010-2023. The observations are quarterly, and the sample comprises 4 banks. I intend to conduct a descriptive study of the variables followed by an integrated standard study.

Prepare national ESS data files for European Social Survey (ESS) according to the specified data protocol. . Key tasks: Data coding: Apply proper coding standards to survey responses, ensuring accurate representation of variables and values. Data file production: Create data files in the required format (e.g., SPSS, Stata) with appropriate variable labels, descriptions, and missing value codes. Deliverables: Submit the data files and additional documents (e.g., variable descriptions, codebook) to the ESS Archive by the specified deadline. Disclosure risk assessment: Implement strategies to minimize the risk of identifying individual respondents from the data (e.g., data recoding, suppression of sensitive information).

I am seeking a qualified quantitative analysis expert to analyze survey data collected in North Syria and Southern Turkey for a research project focusing on the drivers of return for Syrian refugees to Turkey. The dataset comprises two surveys, each with 385 responses. Responsibilities: Conduct statistical analyses using SPSS or STATA. Generate frequencies, cross tabs, t-tests, regressions, and correlations. Create visually compelling charts and visuals based on the analysis. Compile a comprehensive report with statements and interpretations for each test. Adhere to professional report formatting standards. The expert needs to generate the following for each dataset of the two surveys data: 1. Descriptive Analysis: o Conduct descriptive analysis for both surveys. o Pres...

Deadline: January 16th. Stata

I have a dataset of directed dyadic yearly pairs of states. I need to know the maximum and minimum values for each observation across two variables. I have some code that works on some of the cases but not on all. It should be a really quick project and I can check the data to see if it was done properly. I'd also like to have the code.

I'm in immediate need of an experienced STATA expert to conduct a data analysis. The data type is unspecified, thus a broad knowledge of different data types is essential. Key elements for this job: - In-depth knowledge and expertise in STATA - Experience in diverse data types analysis - Able to work with tight deadlines Quick turnaround is crucial, as I need this project completed ASAP. Please bid accordingly and provide your estimated timeframe for completion.

I am looking for a skilled medical researcher to assist me with writing a medic...researcher to assist me with writing a medical report in the field of cardiovascular and respiratory pathology and physiology. The Report requires analyzing the collected data through Stata or Spss and then assisting in writing the research. Skills and Experience: - Strong background in cardiovascular and respiratory diseases and medical research - Experience in analysis of datasets and expertise in Spss or Stata. - Familiarity with both qualitative and quantitative research methodologies - Excellent writing and communication skills - Attention to detail and ability to analyse and interpret research data The project needed to be done in a 3day period Further details will be available o...

I am looking for a freelancer who can help me with my STATA research project. The specific research question or objective is to analyze the impact of X on Y. I have a medium dataset with 1000-5000 observations that needs to be analyzed. I have a specific method in mind for the analysis. I am open to recommendations based on the data, but I already have a preferred statistical method of difference in differences. Ideal skills and experience for this job include: - Proficiency in STATA software - Experience in analyzing medium-sized datasets - Knowledge of the specific statistical method mentioned by the client

I am looking for a statistician who can help me determine how to test for significance in a quasi-experimental study. The main variable I am trying to measure is a continuous outcome. I would prefer the analysis to be done in Python, so proficiency in Python statistical libraries is a must. The ideal candidate should have experien...quasi-experimental study. The main variable I am trying to measure is a continuous outcome. I would prefer the analysis to be done in Python, so proficiency in Python statistical libraries is a must. The ideal candidate should have experience with quasi-experimental study designs and be familiar with testing for significance using synthetic control groups. Knowledge of statistical software such as SPSS, R, or STATA would also be beneficial for comparison...

I have a dataset of all alliances in the international system going back to 1816. I need a loop run over the dataset to create two new dummy variables for if a state ("member" in attached dataset) ever had a previous secret alliance ("1" in "publicanysec" variable in the attached dataset) and then another variable for if the state made a secret alliance in the past five years ("startdate" in the attached dataset). And then another variable for if the state made a secret alliance in the past ten years. I really need the code more than anything. I know it will use the foreach command. Need fairly quick turn around, though it is not a hard loop to run.