PROC SQL UPDATE QUERY

[Pedro08]

Hi,

I am attempting to use a PROC UPDATE query from SAS to update a table in an Access database.

Code as follows;

proc SQL;
UPDATE mydblib.tbl_MPSmisuse m
SET name=(select p.name from platesmatch1 p
WHERE m.id=p.id)
where name in (select name from platesmatch1);
quit;

The code works, however no rows are updated. Any ideas?

ta

 

[madelca100]

see

http://tek-tips.com/viewthread.cfm?qid=1462475&nx=1

That posting (from March 28) might give you some clues.

 

[klaz2002]

I don't think that the SAS/ACCESS engine supports the Select statement in the SET statement (at least in MS Access). any time I have had to use SAS to update a MS Access table I used expicit statements (SET = 'XXXX'). I usually have SAS generate the SQL code and reinclude them in to the program using the %inc etc.

Klaz