The SAS Output Delivery System and reporting techniques

DDE - Trailing Space

Reply
Occasional Contributor
Posts: 11

DDE - Trailing Space

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,

Trusted Advisor
Posts: 1,203

Re: DDE - Trailing Space

Trim(Text)

Occasional Contributor
Posts: 11

Re: DDE - Trailing Space

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

Trusted Advisor
Posts: 1,203

Re: DDE - Trailing Space

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

Ask a Question
Discussion stats
  • 3 replies
  • 758 views
  • 0 likes
  • 2 in conversation