I have several variables I want to combine into one table. When I do the following:   Proc freq data = ICPNEED.data_allcp; Table cg_edu1 cg_edu2 cg_edu3 cg_edu4 cg_edu5 cg_edu6 cg_edu7 cg_edu8 cg_edu9 cg_edu10 cg_edu11 cg_edu12 cg_edu13 cg_edu14; Run;   This is the output:   Also, the dataset I received has the variable name and label for each variable. How do I get the label to show up when I do proc freq? ... View more

Data ICPNEED.data_carerecipients; Set ICPNEED.data_trim4; edu_numeric = edu + 0; If marriage = 1 then cr_marital = 'Married'; Else if marriage = 2 then cr_marital = 'Not married'; Else if marriage = 3 then cr_marital = 'Not married'; Else if marriage = 4 then cr_marital = 'Not married'; Else if marriage = 5 then cr_marital = 'Not married'; Else if marriage = . then cr_marital = " "; if iadl_income_3 = 1 then iadl_income_3rc = '$0-$10,999'; Else if iadl_income_3 = 2 then iadl_income_3rc = '$11,000-$14,999'; if iadl_income_3 = 3 then iadl_income_3rc = '$15,000-$24,999'; Else if iadl_income_3 = 4 then iadl_income_3rc = '$25,000-$34,999'; if iadl_income_3 = 5 then iadl_income_3rc = '$35,000-$49,999'; Else if iadl_income_3 = 6 then iadl_income_3rc = '$50.000-$74,999'; if iadl_income_3 = 7 then iadl_income_3rc = '$75,000-$99,999'; Else if iadl_income_3 = 8 then iadl_income_3rc = '$100,000-or more'; if iadl_income_3 = . then iadl_income_3rc = " "; Format race fmtrace. current_living_dich fmtcurrent_living_dich. sex fmtsex.; Label cr_marital = "Care Recipient Marital Status" current_living_dich = "Current living situation" edu_numeric = "Care Recipient Education" iadl_income_3rc = "Care Recipient Household Income"; run; Proc sort data = ICPNEED.data_carerecipients; by iadl_income_3rc; Run; Proc freq data = ICPNEED.data_carerecipients; Tables race sex current_living_dich cr_marital iadl_income_3rc; Run;     ... View more

I've recoded the marriage variable to represent 1 = married and 0 = not remarried. How and where may I add a labels "married" and " not "married"? I also want to label edu_numeric as "CR Education"   Set ICPNEED.data_trim4; edu_numeric = edu + 0; If marriage = 1 then cr_marital = 1 "married"; Else if marriage = 2 then cr_marital = 0 "not married"; Else if marriage = 3 then cr_marital = 0; Else if marriage = 4 then cr_marital = 0; Else if marriage = 5 then cr_marital = 0; Else if marriage = . then cr_marital = .; Label cr_marital = 'Care Recipient Marital Status'; Run; ... View more

Hi,   I want to add a label to a variable in my data set. Below is what I've done. However, when I run the table for race and current_living_dich, the label "Current living situation" is not showing up.    Data X; Set Y; Label current_living_dich = "Current living situation"; Run;   Proc Format; Value fmtrace 1 = 'White' 2 = 'Black' 3 = 'Asian' 4 = 'Other'; Value fmtcurrent_living_dich 0 = 'Living Alone' 1 = 'Living with ICP or Others'; Run; Data X; Set Y; Format race fmtrace. current_living_dich fmtcurrent_living_dich.; run; Proc freq data = ICPNEED.data_carerecipients; Tables race current_living_dich; Run;       ... View more

The SF-12 is comprised of 12 items each with different dropdown choices. Some have 5: 1 - all of the time 2 - most of the time 3 - a good bit of the time 4 - some of the time 5 - a little of the time 6 - none of the time -9 missing   While others have a different drop down: 0 - not all the time 1 - several days 2 - more than half the days 3 - nearly every day -9 missing   Also, I believe I need to reverse code some of the items looking at the two examples.    So, how do I come up with a total score using SAS coding? And do I need to reverse code? Thank you for your help. I'm a newbie with SAS. ... View more

The variable is now a dichotomous variable with 0 = spousal and 1 = nonspousal. In order to do analyses comparing these two variables against other variables I think I need to make them each a new variable. Is this correct? If yes, how would I go about doing that? If no, how do I compare these two variables against other variables?   Data X Set Y if cg_relation___1 = 1 then cg_relationr = 0; if cg_relation___2 = 1 then cg_relationr = 1; if cg_relation___3 = 1 then cg_relationr = 1; if cg_relation___4 = 1 then cg_relationr = 1; if cg_relation___5 = 1 then cg_relationr = 1; if cg_relation___7 = 1 then cg_relationr = 1; if cg_relation____8 = 1 then cg_relationr = .; if cg_relation____9 = 1 then cg_relationr = .; Run;   Thank you for the help. I'm a newbie. ... View more

Hi,   Newbie here. Working with a data set that has sex and race. I want to look at specific variables by white males, white females black males and black females.    How do I combine sex with race into one variable such as whitemale? Is this possible?   I want to take a variable such as assistance with shopping and compare the four different groups.    What is the best way to do that?   Appreciate the help. Qualitative person trying to do quantitative analysis. ... View more

I have 11 variables with the following categories: 0 = absent 1 = active 2 = inactive 8 = uk/dk 9 = missing   I want to create a new variable for the total score for number of "1's".   Then I want to know how many study participants have 2 or more #1's.   I'm a new user and don't know if I need to do if then statements, sum statement etc.  Appreciate any help.           ... View more