Thanks! I agree. A coworker was able to help me figure this out. To clean up the data in Excel, we can change the reference show blank if the referenced cell is empty: =if(reference cell="","",referenced_cell) We decided to switch the variables within the SAS Macro To switch the variables over in SAS, we added the following into the macro for each affected variable: data ci&cnt(drop=oldvariablename); set ci&cnt; length newvariablename $500.; newvariablename=oldvariablename; run; Thank you for all of your help PaigeMiller!
... View more