topic Re: DDE - Trailing Space in ODS and Base Reporting

DDE - Trailing Space

BMI0776 — Fri, 18 Jul 2014 16:39:30 GMT

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.

Thanks,

Re: DDE - Trailing Space

stat_sas — Fri, 18 Jul 2014 16:49:04 GMT

Trim(Text)

Re: DDE - Trailing Space

BMI0776 — Fri, 18 Jul 2014 16:51:49 GMT

If you mean add that to my SAS code, it already is.

Re: DDE - Trailing Space

stat_sas — Fri, 18 Jul 2014 17:04:09 GMT

Not sure, found something seems close to your problem, where Tom has suggested a solution. May be helpful.

https://communities.sas.com/message/218009#218009