Hello,    I have var A and Var B and using those two I would like to create a combine variable using the value for either A or B depending on the survey year.    So, if survey year=5 then combine variable= values in variable A        if survey year 6 then combine variable= values in variable B   Thanks for your help in advance!  ... View more

Dear users,    I am trying to create a overall total physical activity variable.    This is my code:  *TOTAL LEVEL OF PHYSICAL ACTIVITY (MET_hrs/WEEK); TOTAL_PAHRS= MET_MODRECHRS + MET_VIGRECHRS + MET_MODWORKHRS + MET_VIGWORKHRS;   The problem with this is that is only taking those individuals who have values in each one of these variables and creating one. Which is increasing missing values.    My question is how do I create a variable that includes individuals who do all of these type of physical activity or do only one, or  a combination.     My main goal is to create a final variable that assigns each individuals with a total physical activity MET score.    Thank you for your help!         ... View more

Hi,    I am looking for a way to supress individuals counts when running proc freq. I used proc format and it suppress the individual count but it doesnt change the total and the row percents.    So far my code is    proc format; value hide 1-5='*' other=[comma8.]; run; proc freq data=mydataname; table var1* var2 format=hide.; run;   Thanks! ... View more