04-19-2016 12:49 PM
Hello. I need help with an assignment that I am working on. The instructions are as follows:
Extract and download CPS data from IPUMS site onto your computer
save the data file as SAS data set.
You will need to choose the following variables to include in your extract:
Core Demographic Variables
MARST Marital status
NATIVITY Foreign birthplace or parentage
HISPAN Hispanic origin
EDUC99 Educational attainment, 1990 categories
WKSWORK1 Weeks worked last year
UHRSWORK Usual hours worked per week last year
UNION Union status
PTWEEKS Weeks working part time last year
INCWAGE Wage and salary income
Process the CPS raw data using SAS to get it ready to analyze statistically. The following data processing steps are necessary before going on to step 3:
Drop observations for all non-wage earners.
Generate a new variable for the natural log of earnings from INCWAGE variable.
Generate a new variable for years of education using EDUC99 variable.
Generate a new variable for experience using AGE and EDUC99 variables.
Generate dummy variables for each of the following categories:
4) Marital Status
5) Union Status
I need help with the question that says "generate a new variable for experience using AGE and EDUC99 variables.
I have attached in a word document that SAS code that I have so far (which also defines all the variables).
04-19-2016 12:58 PM
The techniques are exactly the same a mentioned in reponses to your other post. The "difference" is the assignment involves an "AND" condition:
In a datastep something like:
If age le 12 and EDUC99 = <somevalue> then Experience = <what ever you want to assign>;
Ranges considered and assigned should be part of the coursework involved.
04-19-2016 01:15 PM
Please simplify your your code to only the relevant sections.
This is your third question in the assignment so your basically asking each one at a time. Please attempt them first otherwise you won't learn anything. Many people are more than happy to help but to get the most out of your course you should try and learn it.
If you need learning resources - Google SAS UCLA Intro or see SAS Analytics U community forum for free training from SAS including ecourses and YouTube tutorials.
Most of your assignment require if then statements.
See this page on how they work.