topic Re: Filtering in a PROC IMPORT in SAS Programming

Filtering in a PROC IMPORT

TMiller16 — Tue, 22 Nov 2016 14:08:06 GMT

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";

Kurt_Bremser — Tue, 22 Nov 2016 14:14:30 GMT

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

mkeintz — Tue, 22 Nov 2016 14:15:01 GMT

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.