- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-24-2023 07:59 AM
(759 views)
Hello,
I am doing some work on a dataset looking at infectious disease outcomes and their relationship to socioeconomic variables. I have a continuous "number of people in the household outcome" that I am trying to turn into a dichotomous variable (greater than 5 and less than or equal to 5). The variable currently ranges from 2-16. How can I go about coding this?
Thanks so much for your help!
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If I understand you, you want a dummy variable that is true (or 1) if the household is > 5, else it should be 0 (or false).
This is one simple way to calculate this. Note it doesn't take into account what should happen if the continuous variable has a missing value.
data want;
set have;
length is_household_gt_5 8;
/* assuming household_size is continuous */
is_household_gt_5 = (houshold_size > 5);
run;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!