I don't think I was clear, Iapologize.  I want to search ALL values in the "code" column, not just for the value in the corresponding row.  So, it would require some sort of loop, I know that much.   In other words, I need something that would work the same way as:     select * from survey_data where comments like "%(select code from survey_data)%"   I've tried a variation of the above statement using a macro variable within the like statement, but it only reads the first row.  I need a macro to be read as an array.       ... View more

Either I'm reading your response incorrectly, or there's a misunderstanding.  There is only one column which has the values I want to search for.  Call this column "Code".  Each respondent filled it in, and most of them have text in the comments field.  I want to search the "Comments" field for value in the "Code" column.   The Code column is text, but everything is the same length (5).   ... View more

Thanks for the additional help.  I've successfully joined the two data sets using the =* function, and created a score for the match on city name using the COMPLEV function: data COMPARE; set ADDRESS_ID; compscore =  max(1-(complev(city1, city2)/length(city1)), 0); format compscore percent7.; run; I will use matches >=90% (the =* joined some cases which were not valid such as SAN FRANCISCO and SAN BERNARDINO, so a score of sorts is necessary). After I ran my union query, I am left with duplicate rows (should be unique by ID and Code variables), after I did two comparisons: STATE CODE-CITY-ZIP, and STATE CODE - CITY (=*).   The varaible I created to show the type of match (Match_type) has the values:  CITY AND ZIP, CITY, NO MATCH.  How do I remove the duplicate rows on ID AND Code, so that I don't have duplicate rows with different values (e.g. CITY AND ZIP, CITY)?  If two records exist with ID = 50 and Code = FGHJ67, one of which has CITY AND ZIP and one which has CITY for the variable MATCH_TYPE, I want to retain the row which has CITY AND ZIP and remove the other. ... View more

That second option may work...I'm just hoping the AND doesn't leave out too many records which have a missing state or city value in one data set.  Ideally, if city is missing in one, then match on zip.  If zip is missing  then match on street, etc...  Looks like it will have to be several SQL processes with unions, using one field at a time as the join.  Thanks. ... View more

Is there a way to do this with multiple variables at once (e.g. City, State, and street)? ... View more

I prefer to have the bars completely overlapped; I find it much easier to read when the differences between the two are so great.  I also increased the width of the bar corresponding to the 'base' measure so that the reader can differentiate the measures in the lower portion. ... View more

I think I found a way to combine the two graphs I have using SGPANEL, but I cannot get the layout the way I want it.   When I split the panels by size (2 categories) I see all the cases along wht x axis for both categories, leaving a lot of empty space in the panels.  My data set is structured so that each record is ONE of the TWO categories I am splitting the panels by.  How do I remove the empty records from the panels so that each panel only includes the applicable records instead of all?    Here is my working code: proc sgpanel data=DATA_FINAL;   panelby size  ;   rowaxis label="Percent Passed";   colaxis discreteorder=data label = 'Agency'; vbar ID / response=_Passed_by_c stat=mean barwidth=0.4  discreteoffset=0.5  ; vbar ID / response=_Passed_by_P stat=mean barwidth=0.8  discreteoffset=0.5 transparency=.4 ; run; quit; Once I get this fixed, I can work on the bar widths and spacing. ... View more