hanks.
Hello all-
Have a basic question on PROC SQL-
When I run a delete query such as below:
proc sql;
delete from HH.hh_TEST
where Month_and_Year_of_Observation ='NOV 2011';
QUIT;
It only erases two entries at a time instead of all 300. It is running off an Access DB if that makes any difference.
How can I erase all 300 w/o necessary running a loop.
And why does it do this..
Thanks.
Lawrence
Look at using the DIRECT_EXE = DELETE option on the LIBNAME statement.
Look at using the DIRECT_EXE = DELETE option on the LIBNAME statement.
Thanks Poli!
Poli-
OK-I have used the the direct DIRECT_EXE = DELETE option with access 2003.
DO you lnow the provider for Access 2010?
I have the string
libname T oledb provider="Microsoft.Jet.OLEDB.4.0"
properties=('data source'='X:\X.MDB') DIRECT_EXE = DELETE but the provider is not correct for access 10-
I went online and found a different "provider- but that fails too.
Thanks.
Lawrence
I don't have any Access 2010 applications to test on. Problem Note 9731 on the SAS support site might be of some help to you.
OK...WIll take a look. Thanks.
FYI:
The replacement is Microsoft.ACE.OLEDB.12.0 for access 2007/2010
from Microsoft.JET.OLEDB.4.0 for access 2003
in case you migrate up-which I don't recommend!
Lawrence
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.