I want to create a where statement where the variable is equal to 1,3 , or 4 but I am having trouble getting the output I want. I've tried a few methods but I'll just post the last one I tried. Basically I am trying to get the where statement to exclude 2 and only include 1, 3 and 4. Any suggestions? Thank you   Proc means data=data; var chol; class sex; where (2>race>2); run;     ... View more

If I want to calculate the mean of a subgroup (for example I want to calculate the mean cholesterol of White men and White women) and I have variables for cholesterol, race, and sex, how would I combine the variables I need in order to get the averages I am looking for? ... View more

Trying again...     I'm having trouble with a homework assignment. I need to remove rows using a where and set statement but I'm not sure how exactly to do that?  "In a second datastep remove the rows for all candidates except Trump and Clinton. Use a set statement with a where statement." Any help would be greatly appreciated.    More info: A text file called president election 2016.csv on the class website contains data on the 2016 presidential election by county within Minnesota. The first 5 records are as follows: MN,1,AITKIN,0301,5516,9231 MN,1,AITKIN,0401,3134,9231 MN,1,AITKIN,0801,67,9231 MN,1,AITKIN,1101,124,9231 MN,1,AITKIN,1201,263,9231 There are 6 variables: 1) State abbreviation (MN on all records); 2) a county number (1-87); 3) name of county; 4) candidate code (0301=Trump, 0401=Clinton, 0801=Stein, 1101=McMullin, 1201=Johnson); 5) number of votes cast for that candidate in the county; 6) total votes cast in that county. Note: There are five records for each county, one for each of the top 5 candidates. Records for other candidates have been removed. ... View more

Apologies in advance, I am very new to SAS and am having trouble with an assignment.  I'm getting error 161-185 no matching DO/SELECT statement. The assignment is described below:  Within the datastep create the following new variables: (a) A new variable called agecat that divides age into 5 categories:45-49;50-54;55-59;60- 64;65-69. Give values 1-5 for the categories. (b) A new variable called income40 equal to 0 if income is less than $40,000 and equal to 1 if income is $40,000 or more. (c) A new variable called collgrad equal to 0 if the participant did not graduate from college and equal to 1 if the participant graduated from college (see study forms for income and education categories) (d) A new variable that is the lowest of the two serum potassium values   This is my SAS code right now (still haven't gotten to parts C and D):   libname t '/home/u58860515/'; data tdata; set t.tomhs (keep=age sex income educ hdlbl potassbl potass12); if age = 45-49 then agecat = 1; else if age = 50-54 then agecat = 2; else if age = 55-59 then agecat = 3; else if age = 60-64 then agecat = 4; else if age = 65-69 then agecat = 5; end; if income < 40000 then income40 = 0; else if income > 40000 then income40 = 1; end; run;   ... View more