Solved: Filtering in a PROC IMPORT

TMiller16 · Posted 11-22-2016 09:08 AM

When doing a PROC IMPORT, can I add a filter here? If so, where? I am a basic SAS user so any help would be appreciated.

PROC IMPORT TABLE="Sales" OUT=Sales

DBMS=access

REPLACE;

DATABASE="\\americredit.com\db_files\AOC\SA\AR\Analytics\RDW.accdb";

mkeintz · Posted 11-22-2016 09:15 AM

You can use what are called "data set name parameters", and a "where" expression can be one of those paramenters.

PROC IMPORT TABLE="Sales" OUT=Sales (where=(logical expression here));

DBMS=access

REPLACE;

DATABASE="\\americredit.com\db_files\AOC\SA\AR\Analytics\RDW.accdb";

Unfortunately the filter is applied when writing the output, not on reading the input.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Kurt_Bremser · Posted 11-22-2016 09:14 AM

Try to add a where= dataset option to your output dataset Sales.

mkeintz · Posted 11-22-2016 09:15 AM

You can use what are called "data set name parameters", and a "where" expression can be one of those paramenters.

PROC IMPORT TABLE="Sales" OUT=Sales (where=(logical expression here));

DBMS=access

REPLACE;

DATABASE="\\americredit.com\db_files\AOC\SA\AR\Analytics\RDW.accdb";

Unfortunately the filter is applied when writing the output, not on reading the input.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Filtering in a PROC IMPORT