topic Reading external files in SAS in SAS Programming

Reading external files in SAS

Aexor — Sat, 20 Feb 2021 19:22:53 GMT

Hello,

Any methods to reacd external files in SAS except INFILE ??

Re: Reading external files in SAS

Tom — Sat, 20 Feb 2021 19:36:57 GMT

@Aexor wrote:

Hello,

Any methods to reacd external files in SAS except INFILE ??

PROC IMPORT can be used to convert external files into SAS datasets. Check the documentation for the types of files it can read. Typically you use this to convert data that looks like a dataset, like a spreadsheet (Excel files for example), another database (dBASE, SPSS, STATA, etc)

Re: Reading external files in SAS

ballardw — Sat, 20 Feb 2021 22:21:56 GMT

SAS/Access has modules to connect to many data sources.

ODBC can be used to connect to some.

The LIBNAME can also connect to some file types.

Re: Reading external files in SAS

mkeintz — Sun, 21 Feb 2021 04:00:50 GMT

Would it qualify as not using INFILE if the external file had a "datalines;" statement as its first line. If so, then such a file can be %INCLUDEd (like c:\temp\t.txt below in the second data step.

filename f 'c:\temp\t.txt';
data _null_;
  file f;
  put 'datalines;';
  put '1 1 1';
  put '2 2 2';
run;

data t;
  input a b c;
  %include 'c:\temp\t.txt';
run;

Those who are facile with their operating system commands can probably create a pipe with the "datalines;" statement dynamically inserted before streaming the file in question. Then just %INCLUDE the pipe.

Re: Reading external files in SAS

Kurt_Bremser — Sun, 21 Feb 2021 10:30:45 GMT

When reading text files, you will always have an INFILE statement, either written by you or by the IMPORT procedure.

What's so bad about INFILE? Did it bite you?

Re: Reading external files in SAS

Aexor — Tue, 23 Feb 2021 14:44:30 GMT

Thanks 🙂 . I always prefer INFILE .
this question is asked by my colleague though i dont know any other ways except INFILE
so asked for help 🙂

This community is amazing. Thank you all!!