** ************************************************************************************;
** Macros for exporting and importing SAS data to/from text files, csv files and xls files
** April 4th, 2005, Søren Højsgaard
**
** Note: Depending on your version of Excel, you may have to replace 'DBMS=EXCEL5' with
** 'DBMS=EXCEL2000' or something similar
** ************************************************************************************;

%macro exportascii (data, outfile);
options missing='*';
PROC EXPORT DATA= &data
     OUTFILE= &outfile  DBMS=DLM REPLACE; RUN;
%mend;

%macro exportexcel (data, outfile);
PROC EXPORT DATA= &data
     OUTFILE= &outfile  DBMS=EXCEL5 REPLACE; RUN;
%mend;

%macro exportcsv (data, outfile);
PROC EXPORT DATA= &data
     OUTFILE= &outfile  DBMS=CSV REPLACE; RUN;
%mend;

%macro importexcel (data, infile);
PROC IMPORT OUT= &data
     DATAFILE= &infile  DBMS=EXCEL5 REPLACE; GETNAMES=YES; RUN;
%mend;

%macro importcsv (data, infile);
PROC IMPORT OUT= &data
     DATAFILE= &infile  DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; RUN;
%mend;