When a variable is used in an IF SAS either expects a comparison such as =, <, >, ge or similar if there is a second variable mentioned.   Phoebe, Fredo and Lego are currently numeric variables with values of 0 or 1. Depending on what you are attempting then the statement should be   If Phoebe =1 AND Fredo=1 and Lego=1; if you want records with all three sets contributing. This can be shortened to : If Phoebe And Fredo And Lego; because SAS will treat non-0 and non-missing values as "True" in a comparison. ... View more

Step 1: get away from using proc import. Take the data steps created by proc import (you find it in the log), and make sure that the variable county has sufficient and equal length in all three steps. Then (step 2) convert county to uppercase in Vocational_Rehabilitation_Successful_Closures_Average_Hours_Worked_By_County__SFY_2014.csv, and you should be fine. As far as i can see, LOS ANGELES is consistently used, so I guess you have a length issue stemming from the guessing of proc import.   See Maxim 22. ... View more