07-18-2014 12:39 PM
I am using DDE to write data to a EXCEL report template. One of the columns is TEXT that is being used in VLOOKUP formula in EXCEL. When the column is written to EXCEL, there is a tailing space that is causing my data not to match.
For example, the value in my SAS data is "TEST123" but in EXCEL i see "TEST123 "
how to I tell SAS to remove that trailing SPACE.