I ran into a strange merge situation and am hoping someone can help me understand it. Here's a simplified version (the real one involved more datasets and more variables):   Dataset ONE, created by Proc Import from an Excel file, contained 2 variables: barcode and id   Dataset TWO, created from other SAS datasets, contained 3 variables: BARCODE, ID, and TRIAL   Dataset THREE, created by merging ONE and TWO by barcode (after sorting both datasets by barcode), had all 3 variables, as expected, but data for TRIAL and ID were missing.   After confirming type, length, label and format of all variables were identical, I changed the case of ONE variables to match TWO variables (i.e., all upper case, rather than all lowercase). I did not change any values, only variable names. When I did this, the merge worked and no values were missing.   If SAS variable names are case insensitive, how can this be explained? ... View more

I have a dataset with 66 individual observations but the proc report is showing column totals instead and I don't know why. Here's my code:   *************   ods pdf (ID=work) file="Compliance.pdf" style=styles.plateau; proc report data=compliance nowd; column week complied enrolled rate; define week       /"Week"      style=[cellwidth=30mm textalign=center]; define complied   /"Complied"  style=[cellwidth=30mm textalign=center]; define enrolled   /"Enrolled"  style=[cellwidth=30mm textalign=center]; define rate       /"Rate"      style=[cellwidth=30mm textalign=center]; run; ods pdf (ID=work) close;   *************   As a workaround, I tried inserting "display" after each slash (e.g., define week /display "Week") and this fixed the problem but I don't know why it is necessary as I have never had to insert "display" to see individual observations in a proc report before. ... View more