Proc import vs FILENAME REFFILE

hwangnyc — Sun, 09 Dec 2018 02:19:50 GMT

Hi everyone,

Can someone tell me the pros and cons of Proc import vs FILENAME REFFILE for importing in excel files? Why would you do one vs. the other? Thank you!

Re: Proc import vs FILENAME REFFILE

Reeza — Sun, 09 Dec 2018 03:23:16 GMT

FILENAME creates a reference to a file, either one that already exists or creating one. In terms of importing data, usually when someone mentions FILENAME that's in conjunction with a data step. However, a data step is for text files, it cannot be used to read an Excel file.

PROC IMPORT or a LIBNAME statement are the primary ways to read an Excel file.

Other ways include DDE or ODBC but they aren't used as much. DDE should not be used for new processes, it's really old technology and is unsafe.

@hwangnyc wrote:

Hi everyone,

Can someone tell me the pros and cons of Proc import vs FILENAME REFFILE for importing in excel files? Why would you do one vs. the other? Thank you!

HW

topic Re: Proc import vs FILENAME REFFILE in New SAS User

Proc import vs FILENAME REFFILE

Re: Proc import vs FILENAME REFFILE