%let pfad = z:\Transfer\;

/**** Einfacher Export als CSV ***/

data mysample;
    input datumswert ddmmyy10. @11 namen $ kommazahlen andere;
    format datumswert ddmmyyp10. kommazahlen numx10.4;

datalines;
21.03.2011 Herbert 12.5 345
12.10.2011 Hans 34.7 9234
13.07.2011 Hugo 0.43123 123
09.08.2011 Hilbert 5432.2 44123
;

proc export data=mysample outfile="&pfad.beispiel1.csv" 
        dbms = dlm
        replace;
    delimiter = ';';
run;


/*** CSV Export via ODS Tagsets ***/
ods csv file = "&pfad.beispiel2.xls" options(Delimiter=';');
proc print data = mysample noobs;
run;
ods csv close;

ods csv file = "&pfad.csv.csv" options(doc='help');

/*** ExcelXP Tagset ***/
ods markup tagset=ExcelXP file = "&pfad.beispiel3.xls";
proc print data = mysample noobs;
run;
ods markup close;

ods tagsets.excelxp file="&pfad.beispiel4.xls"
    options ( Sheet_Name = 'Klein' );
proc print data=mysample noobs;
    where datumswert > "01AUG2011"d; 
run;
ods tagsets.excelxp options ( Sheet_Name = 'Gross' );
proc print data=mysample noobs;
    where datumswert <= "01AUG2011"d; 
run;
ods _all_ close;

ods markup tagset=ExcelXP file = "&pfad.beispiel5.xls" 
    options ( Absolute_Column_Width = '10,5,2,2' );
proc print data = mysample noobs;
run;
ods markup close;