I Need Help With The Following Problem Use The Microsoft Excel Spreadsheet Creat
I need help with the following problem:
Use the Microsoft® Excel® spreadsheet created in the Week One individual assignment.
Write a SAS® program to access the Microsoft® Excel® spreadsheet and select these four specific data items:
- Male, worked full-time with earnings of $55,000 to $100,000 or more population estimate
- Female, worked full-time with earnings of $55,000 to $100,000 or more population estimate
- Male, worked full-time other category with earnings of $55,000 to $100,000 or more population estimate
- Female, worked full-time other category with earnings of $55,000 to $100,000 or more population estimate
Create a comma-delimited raw data file to store information that includes gender, earnings categories, and number of individuals in each category for only the data indicated above.