I´m unable to remove all the blanks (especially trailing blanks) from character variables. I have the following macrovariables: &Period1 &Period2 &Period3 &Period4 and want another macrovariable that´s a concatenation of these. So if the values of these macro variables is 1, 2, 3 and 4 respectively I want a macrovariable called &Period1_4 that has the value 1234, and without any blanks. I´ve tried to achive that using this method data _NULL_; period1_4=compress("&period1.&period2.&period3.&period4.", " "); format period1_4 $4.; call symput('period1_4', period1_4); run; but I just can´t get rid of those blanks..... If I execute      data _NULL_;      x="&period1_4.testing1234";      put x;      run; I get the following result: 1234                                            testing1234 I´ve tried the trim and trimn functions to but nothing helps so I need some advice from you out there. ... View more

I like to use  tagsets.excelxp to export output to excel. The problem is I can never export more than one table to the same file, even if I specify different sheets each time. The file still gets overwritten. Is there a solution?   ... View more

I would like to do what it says in the title of this thread but can´t find a way to do it. Any solutions?                ... View more