Trim Spaces

Babloo — Tue, 20 Feb 2018 09:41:17 GMT

I've a SAS program where it reads a SAS dataset and convert it to the XML file. However, I observed that there is an extra space is appended with few of the variables in the output XML file and I want to remove the extra spaces as highlighted in yellow below. Since the values are coming from the dataset, I think I've apply trim function to the variables 'dateRenewal' and 'clause_Base' but I'm not certain how to apply. Appreciate if someone of you guide me here.

Snippet of SAS program:

put '<dateRenewal>' dateRenewal '</dateRenewal>';
put '<clauseCode>' clause_Base '</clauseCode>';

Snippet of Output XML file:

topic Trim Spaces in SAS Programming

Trim Spaces

Re: Trim Spaces