Syntax Generator on paneldata.org¶
Paneldata allows registered users to collect and save their research-relevant variables in a variable basket. These variables can be simply written into a single data set with the script generator. The script generator helps you with data management and can save valuable working time.
For our experienced users, we have temporarily equipped the old soepinfo with the current data, so that the variables basket function and the script generator can also be used there.
Click on the “Register/ log in” to log in to paneldata.org.
If you have already registered, you can login in the “User login” area. As a new user you can register at “Register here”. Once you have logged in successfully, you have access to the variable basket and the syntax generator.
To access the activated functions, click on the navigation field “My baskets”. You will be taken to your personal workspace on paneldata.org.
“My baskets” displays your created variable baskets. If you click on “Create basket”, you can create a new basket.
When creating the basket, first define the name of the variable basket. The name must be lower case to be accepted by Paneldata. Optionally, you can assign a label and enter a description. You can create a security key via “Security token”. Finally, you select the study that you want to use as a database for your research. Now click on “Create basket” and your newly created variable basket appears in the interface.
Now search for your relevant variables on paneldata.org and add them to your individual basket. For example, you are interested in the monthly net household income. If you do not know the variable name, you can find the superordinate concept using the topic search. Click on the navigation field “paneldata.org” to get to the main page. Select the study SOEP-Core and click on the navigation field “Topics”.
Check the different topics for income-relevant concepts and select “income, taxes, and social security”.
Browse the topic list and you will reach the sub-topic “household income hhi”. There you will find the concept you are looking for under “monthly income moi”. Click on the concept and you will see the history of variables, possible links to other studies and perhaps the question in metadata-based form.
Select the variable of your desired study SOEP-Core and you will reach the variable overview with important information about the variable. In the variable overview, you should make sure that the variable also meets your requirements.
When logged in, the Basket area appears in the overview of variables. Your baskets are listed there. If you want to add the variable to a basket, click on “Add to basket”. If the variable is already in the basket and you want to remove it, select “Remove from basket”. If you want to create a new basket within the overview of variables, click on “Create a new basket” to go to basket creation and its variable is automatically placed in the new basket. You can access the basket overview by clicking on the name of your basket in the “Basket” section. Alternatively, you can click on the navigation field “My baskets” and you will also return to the basket overview.
Click on the basket with your added variable and you will get an overview of all variables in your basket. With “Add all” you add the variables of all survey waves and the shopping cart is highlighted in green. If you are interested in a specific survey period, you can select the wave-specific variables by clicking on the shopping cart. Click on “Remove all” to remove the variable from your basket. Furthermore, you can export your chosen variables to a CSV-File (Comma Seperated Value-File) and for example import them in STATA.
Once you have filled your basket and selected the desired survey waves, you can merge all variables into one data set. To do this, click on “New script using the soep-xxx generator” in the “Actions” area. You can choose between different statistic programs.
In the script generator you can create a script that matches your preferred variables. Specify the name of your script. Select the statistics program you are using. Then enter the path where you have stored your data records in the “Input path”. In the “Output path” you write your desired output path for the created data set.
In the “Analysis Unit” section, you decide whether all persons are considered individually within the household (“Individual”) or whether you are only interested in the household as a whole (“Household”). With “Sample composition” you can choose between “balanced” and “unbalanced”. If you select “balanced”, you will receive a data set without missing codes. The respondents provided information on all variables. For more information about balanced and unbalanced datasets visit the chapter Principles of Data Analysis. Under “Age group” you can limit the respondents. When you are satisfied with your settings, click on “Update Script” and your script will be created.
If you click on the “raw script” button, the script is displayed in text form. Copy it to your statistics software. To name the data set correctly, you should change the name of the data set in the script. Execute the script with your statistics software and you will receive your data set with all your choosen variables.