Syntax, PROC EXPORT
statement:
PROC EXPORT DATA=<libref.>SAS-data-set
OUTFILE= “filename” <DBMS=identifier>; <REPLACE>;
|
Identifier
|
Output Data Source
|
Extension
|
CSV
|
Delimited file (comma-separated
values)
|
.csv
|
DLM
|
Delimited file (default
delimiter is a space)
|
|
JMP
|
JMP files, Version 7
or later format
|
.jmp
|
TAB
|
Delimited file (tab-delimited
values)
|
.txt
|
proc export data=cert.leukemia (where=(survived=1)) /*#1*/ outfile="C:certleukemia_surv.csv" /*#2*/ dbms=csv /*#3*/ replace; /*#4*/ run;
1 | The DATA= option specifies the input file. The WHERE option requests a subset of the observations. |
2 | The OUTFILE= option specifies the output file. |
3 | The DBMS= option specifies that the output file is a CSV file |
4 | The REPLACE option overwrites an existing file. |