How would I do this using a FORMAT statement? ... View more

Hi Tom,  When I create a format statement for race, they are all working except the "Asian or Pacific Islander, no specific (individual) race". For some reason, it will not format? I copied and pasted directly from the excel spreadsheet to make sure I had the spaces and spelling correct, but it still won't format. I also tried creating IF statements, and they all work except the one previously mentioned. There are no errors in my log. Any suggestions?   value $racegrp 'Black or African American' = 'African American' 'Asian Indian' ,'Asian or Pacific Islander, no specific (individual) race' ,'Other Asian or Pacific Islander' = 'Asian/Pacific Islander' ; run; ... View more

Hi Mark, Last question. If I have 5 years worth of air pollution data, but only 1 year worth of poultry farms, could I compare the mean air pollution to poultry farms with a Pearson Correlation? The scatter plot above is an example of the mean levels for the past 5 years and the # of poultry farms for one year. ... View more

My code: proc sgplot data=Iowa; reg x=Poultry_Farms y=Air_Pollution/ clm cli; run;   Should I even do a scatter plot since one variable is continuous and one is discrete? I think I'm confusing myself. My goal is to see if there is a correlation between the two. ... View more

Question: Would I graph or use a scatter plot? I know air pollution levels are a continuous variable, but is number of poultry farms in each county continuous or discrete? ... View more

Hi Markus, So once I do a scatter plot and I see that the relationship is not linear, does that sufficiently answer my research question (To evaluate if air pollution levels are greater in counties near poultry farms), or should I do another test? ... View more

data Female; set Original; if race= 'Black or African American' then race= 'African American'; else if race in ( 'Asian Indian', 'Asian or Pacific Islander, no specific (individual) race', 'Other Asian or Pacific Islander' ) then race= 'Asian/Pacific Islander'; run; if gender eq 'Female'; if income eq 'High’; if race= 'Unknown’ then delete; keep race income gender occupation; run; proc print data=Female (obs=20); run; I should note that Gender is my observation while race,income, and occupation are my variables ... View more

Thank you! If I have other "IF" statements, do those go after those?    What order do these statements go below? When I run this I get the error "Statement is not valid or is used out of proper order" Example: if gender eq 'Female'; if income= 'High'; if race= 'Unknown' then delete; keep race income gender occupation; run; ... View more