Exporting a SAS dataset to Microsoft Excel

There are atleast two ways to export a SAS dataset to Microsoft Excel.

Proc Export


PROC EXPORT DATA=datasetname
OUTFILE="/usr2/users/student/mkaushik/ names9900.csv"
DBMS=csv
REPLACE;
delimiter=','; */
RUN;

The program (say atlantis) that includes this, should be submitted with the -noterminal option to i.e.:

sas atlantis -noterminal


ODS
ODS html FILE='/usr2/users/student/mkaushik/AIIMS/becker/try2.xls';
PROC PRINT DATA =&dataset NOOBS;
RUN;
ODS html CLOSE;


Use it when a few observations need to be extracted and sent it for review, additional data entry, data confirmation.