In SAS, how do I create an ASCII text file from a SAS data set?
To create an ASCII text file from a SAS data set, use the
PUT statements in a
Suppose you have a SAS data file in the
test.sas7bdat, which contains the five
v5. You wish to store
these variables in an ASCII file called
test.txt. Consider the following SAS code:
LIBNAME old 'c:\sasdata'; DATA _NULL_; SET old.test; FILE 'c:\sasdata\test.txt'; PUT v1 v2 v3 v4 v5; RUN;
LIBNAME statement assigns a library reference
(libref) to the location of the permanent SAS data set. This libref
is given an alias of
old. Once the library reference is
set, you then open a data set in a
DATA step. The
SET statement reads the permanent SAS data set
test from the library
old. The data set
old.test) is referred in the form of
libref is the alias set
LIBNAME statement and
name is the
actual data file name without its extension.
FILE statement declares a file in which SAS stores
the output of the
DATA step in the format specified in
PUT statement. For the listed format, the
PUT statement is followed by a list of the variables you
wish to store in the output file
If you have questions about using statistical and mathematical software at Indiana University, email UITS Research Analytics. Research Analytics is located on the IU Bloomington campus at Woodburn Hall 200, and is open for consultation by appointment Monday-Friday 9am-5pm.
This is document acxh in the Knowledge Base.
Last modified on 2014-06-25.
- Fill out this form to submit your issue to the UITS Support Center.
- Please note that you must be affiliated with Indiana University to receive support.
- All fields are required.