As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Changing the Delimiter when Using ODS CSV

From sasCommunity
Jump to: navigation, search

ODS CSV and PROC PRINT can be used to easily produce a comma-delimited text file from a SAS data set with either variable names or labels in the first record of the file. You might not know that you can change the delimiter in the text file from a comma to any character you choose, for example...

ods csv file='z:\class.txt' options(delimiter='|');
proc print data=sashelp.class noobs;
run;
ods csv close;

will produce a pipe-delimited file (CLASS.TXT) a portion of which looks as follows ...

"Name"|"Sex"|"Age"|"Height"|"Weight"
"Joyce"|"F"|11|51.3|50.5
"Jane"|"F"|12|59.8|84.5

If the ODS CSV option does not work for you, download an updated CSV tagset at the "see also" link.

Submitted By Mike Zdeb

....updated CSV tagset see also

....read about ODS CSV (page 7) see also