10-Exporting-Your-Data推荐.pdf

The Little SAS Book: A Primer, Fifth Edition Chapter 10: Exporting Your Data When we try to pick out anything by itself, we find it hitched to everything in the Universe. John Muir From My First Summer in the Sierra by John Muir. Public domain. 10.1 Methods for Exporting Your Data In our ever increasingly complex world, people often need to transfer data from one application to another. Fortunately, SAS gives you many options for doing this. The types of files that you can create and the methods available for creating those files depend on what operating environment you are using and whether you have SAS/ACCESS software. Methods for exporting data to other applications fall into these general categories: n creating delimited or text files that the other software can read n creating files in formats like HTML, RTF, or XML that the other software can read n writing the data in the other softwares native format Creating Delimited and Text Files No matter what your environment, you can always create delimited or text files and most software has the ability to read these types of data files. n The DATA step, discussed in section 10.5, gives you the most control over the format of your files, but requires the most steps. n The Export Wizard, discussed in section 10.2, and the EXPORT procedure, discussed in section 10.3, are easy to use, but you have less control over the result and not everyone has access to these tools. n The Output Delivery System (ODS), discussed in section 10.6, can create comma-separated values (CSV) files from any procedure output and a simple PROC PRINT will produce a reasonable file for importing into other programs. Creating HTML, RTF, and XML Files Using ODS, discussed in section 10.6, you can create HTML, RTF, and XML files from any procedure output. Many applications can read data in these