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";
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\RD
Unfortunately the filter is applied when writing the output, not on reading the input.
Try to add a where= dataset option to your output dataset Sales.
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\RD
Unfortunately the filter is applied when writing the output, not on reading the input.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.