BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
graingerad12
Calcite | Level 5

Hello. I am doing an assignment in which I am supposed to extract and download CPS data from IPUMS site 

(https://cps.ipums.org/cps-action/variables/group). The variables in the data set are as follows:

 

 

Person Record

Core Demographic Variables

AGE Age

SEX Gender

RACE Race

MARST Marital status

Ethnicity/Nativity Variables

NATIVITY Foreign birthplace or parentage

HISPAN Hispanic origin

Education Variables

EDUC99 Educational attainment, 1990 categories

Work Variables

WKSWORK1 Weeks worked last year

UHRSWORK Usual hours worked per week last year
UNION Union status
PTWEEKS Weeks working part time last year

Income Variables

 INCWAGE Wage and salary income

 

I am having trouble executing a few steps that are required in the assignment. For example, it says to "drop observations for all non-wage earners." What would the code look like in order to do that? 

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

SAS uses an IF statement to remove observations.  You could add either of these at the end of your DATA step (and possibly other similar statements):

 

if wkswork1 > 0;

if incwage > 0;

 

It's up to you to decide which variables to use, and what conditions will select the proper observations.

View solution in original post

1 REPLY 1
Astounding
PROC Star

SAS uses an IF statement to remove observations.  You could add either of these at the end of your DATA step (and possibly other similar statements):

 

if wkswork1 > 0;

if incwage > 0;

 

It's up to you to decide which variables to use, and what conditions will select the proper observations.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 790 views
  • 0 likes
  • 2 in conversation