You can check the definition of each variable in the file variables_description.csv, which is located in the same folder than the database.
This is the email your received from your colleague:Īfter a week putting together the data from the Census, the American Community Survey and the reports from the utility companies, I am happy to share with you this first version of this dataset. Is there a clear relation at the neighborhoods level between the fraction of latino population and the number of leaks per 10,000 inhabitants?.Leaks in block groups per town, when we only consider those with at least a hundred inhabitants? What is the average, standard deviation, minimum, and maximum number of.What is the total number of leaks in each Neighborhood?.By answering this questions you would make your point clear: Although in this very first meeting you did not expect to have data to share, showing them some aggregate figures about the extent of the gas leak problem in Boston and Cambridge would definitely be helpful to make a future cooperation with their organization more likely. You have received the GasLeaks.csvĭatabase from a colleague at 11:00 AM, and you have an important meeting with members of the Boston Public Health Commission at noon. Suppose you work as a policy expert in an environmental NGO that advocates for fixing gas leaks in the Great Boston Area (as for example HEET). Exercise 1: Preparing a meeting on a hurry Assignment We will now give Stata some commands to obtain useful information about our database, this will be our first in-class exercise. The database should now be ordered by that variable! Try editing it to sort by another variable and type browse again to see what happened. The command is now written into your Command window. Now you can see that your Review window is populated with commands! Click in one of the commands that order the database. Try ordering the data by different columns (right click on a column).Įxit the Data Editor Window. There we go! We can inspect our database. The command window is where we can give instructions to Stata using commands.In this case, it prints the import used command and gives us some useful information of the result. The Result window (center top) prints the result of the instructions we have provided.The Properties window (down right) shows some information of the loaded database.The Variables window (top right) lists the variables of the loaded database.Whenever you give an instruction to Stata using the top menu, Stata automatically picks the reveland command and runs it in the command line. There is one command now, which is the result of loading the database. The Review window (left) has the history of the commands we have given to Stata in the current session (since the last time we opened it).
DOES NOT EQUAL SIGN STATA WINDOWS
In this case, observations are all the census block groups of Boston and Cambridge, and variables are some demographics from the 2010 Census and data on the status of gas leaks reported by utility companies in 2016 (more on the data later).Īfter loading the database, some of our windows have been populated with information: As is generally the case in Excel, Stata follows the convention that each row represents an observation and each column a variable. Double click the file to inspect it in Excel (do not save afterwards!). Select file > Import > Text Data from the top menu and browse for the file data/original/gasData.csv in the folder of this class.
DOES NOT EQUAL SIGN STATA DOWNLOAD
So lets lead our first database to have some action!įirst, download and unzip the materials for this class. In most cases, the things we want to do are only meaningful when there is a database loaded. Show you the output of the instructions you gave (rest of the windows).Can give instructions to Stata to do something (command window) or,.All of the windows in this workspace are instances that either: To have some action, we need to load a database. Nothing seems too interesting, there is only a welcome message in the Results window with some information about our version and license. Four windows organized as a consolidated workspace will automatically pop-up. Class 1: From Excel to Stata A first approximation: Stata as an enhanced excel
0 kommentar(er)
