That is great, but it will be very long since the dataset covers almost 50 years. I think I need to go with Do statement, but I'm not good at that. Thank you! ... View more

They are the true values of the SAS, numeric, date ...... ... View more

Sorry, it seems it's confusing now. Let's start from beginning: I have actually 5 variables that I want to put together. they are something like this as I mentioned before: Var_1 who does the cleaning? content: code Myself 1 spouse 2 both 3 NA 6 NS 9 Var_2 who does the washing? content: code Myself 1 spouse 2 both 3 NA 6 NS 9 Var_2 who does the cooking? content: code Myself 1 spouse 2 both 3 NA 6 NS 9 Var_3 who does the caregiving? content: code Myself 1 spouse 2 both 3 NA 6 NS 9 Var_1 who does the teaching? content: code Myself 1 spouse 2 both 3 NA 6 NS 9 Let's say that I cannot disaggregate the data for sex due to confidentiality. Instead, I can combine all variables together as the total task and then compute how many percent of male vs female respond myself vs spouse vs both . But, I cannot simply sum up the contents because a respondent could reply myself for one variable, then spouse for another one and …… what I want to have at the end is a derived variable of total task from those 5 variables. Then I can do: proc freq data=my data; tables sex*total task; run; , and I will have the rate of total task for each sex. I need this by tomorrow and none of my codes seem work well. Thank you! ... View more

Hi Reeza, But first I have to create this Var_4 (as total task) from those 3 of individual tasks. ... View more

let's say that respondent#1 answer 'I' for Var-1 'I' for var_2 and both for var-3, then respondent#2 replied sister for var_1, I for var_2 and I for var_3 and …. so on. I set thresholds for total (all responds for I, sister and both) and subtotal (all I or all sister or all both) and then put condition and make var_4 as total tasks with the categories of I, sister, myself, NA and NS. ... View more

I want the rates for total of those tasks. As I said, i'd like to make a variable out of those 3 named total task. Then find out the rate of respondents for each categories of I (myself) vs sister vs both. Thanks. ... View more

I have these 3 variables in my dataset. I wants to create a derived variable out of these 3 as total task like this: Var_4   total task   I             1 sister      2 both       3 NA         6 NS         9   ... View more

I have these 3 variables in my dataset. I wants to create a derived variable out of these 3 as total task like this: Var_4   total task   I             1 sister      2 both       3 NA         6 NS         9   ... View more

I mean the rates of derived variable of total task. ... View more

Var_1   Var_2  Var_3   each has 5 reply categories: I (myself), sister, both, NA (not applicable) and NS (not stated). Let's say that i have 1000 respondents and i want to see out of these 1000 what the rates are for myself vs sister vs both. Thank you!  ... View more

Sorry I posted the question before finish it. i sent the full question right after that. thanks. ... View more