Can sas read *.txt document ?

shiyiming

Can sas read *.txt document ?

shiyiming

Yes, SAS can do it.  Please take a reference to FILENAME, INFILE and INPUT statements.

shiyiming

SAS does read .txt files. However, from my experience, when you are using INFILE and INPUT statements to read in the data from a .txt file, you will be having great difficulty if the file contains variable names.

First of all, SAS is not expecting to column names in a text file. So you will have to open .txt in another package (eg. wordpad, word) delete the row with the variable names and save this file.
Second, you will need to specify the directory of where the file is located.

There are several different ways that you can read a dataset into SAS. Normally, I prefer using PROC IMPORT command, because it specifies the variable names and missing data.

Cheers

shiyiming

Thanks so much for your help.

shiyiming

if you use "firstobs=2",you don't need edit data.

[quote="Trinity":1566d]SAS does read .txt files. However, from my experience, when you are using INFILE and INPUT statements to read in the data from a .txt file, you will be having great difficulty if the file contains variable names.

First of all, SAS is not expecting to column names in a text file. So you will have to open .txt in another package (eg. wordpad, word) delete the row with the variable names and save this file.
Second, you will need to specify the directory of where the file is located.

There are several different ways that you can read a dataset into SAS. Normally, I prefer using PROC IMPORT command, because it specifies the variable names and missing data.

Cheers[/quote:1566d]