Hi Chis
Thank you very much for your list of excel export methods.

I have a little problem, maybe you can tell me the "correct" way to export my data.
My following example is with missing data and I need to change the negative values, because I need to sum in further steps, therefore we decided to use .n.
When I use "View in Excel" (right-klick on the dataset) I got a correct output, but I want to export automatically for QC.
When I use PROC EXPORT, the output is wrong because the "N" will be "deleted".
Does anyone know why?

data test;
infile datalines delimiter="," ;
input num char $;
datalines;
1,1
2,2
-2,-2
;

DATA test1 ;
SET test ;
IF num < 0 THEN num = .n ;
char = cats(num) ;
RUN ;

PROC EXPORT DATA= test1
OUTFILE= "\test1.xlsx"
DBMS=XLSX REPLACE;
SHEET="test1";
NEWFILE=YES;
RUN;