I had a question regarding exporting data from Windows SAS to excel.
I am using a DDE statement to export the data to excel from SAS, but what is happening is, when the data is getting exported, there is a trailing blank space after the value.
For eg: "Shalini" is getting exported as "Shalini ".
I have confirmed that there are no trailing blank spaces in the raw data, this problem occurs only when the exporting is happening.
Do you know how I could avoid this, or why this could be happening.
Also, in DDE is there a possibility of exporting data into a defined named range instead of a range of cells?