Update query no longer working

yelkenli — Wed, 20 Feb 2019 15:30:00 GMT

I have a simple update query that worked in the past but does not now. expects an "=", but i am sure if have it in there. any idea what i am doing wrong?

PROC SQL;
	update sasuser.parts as u
	set u.part_system = (select sf.Subsystem FROM sasuser.whereused sf where u.pnum=sf.part number)
	where missing(u.'part_system'n);
quit;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 PROC SQL;
57 update sasuser.parts as u
58 set u.part_system = (select sf.Subsystem
_
73
76
ERROR 73-322: Expecting an =.

ERROR 76-322: Syntax error, statement will be ignored.

59 FROM sasuser.whereused sf
60 where u.pnum=sf.part number)
61 where missing(u.'part_system'n);
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
62 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2019-02-20T10:19:54,419-05:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| |
_DISARM| 30830592| _DISARM| 30568448| _DISARM| 13| _DISARM| 13| _DISARM| 0| _DISARM| 14464| _DISARM| 0.000000| _DISARM|
0.006735| _DISARM| 1866295194.412948| _DISARM| 1866295194.419683| _DISARM| 0.000000| _DISARM| | _ENDDISARM
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

63
64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 

Re: Update query no longer working

Kurt_Bremser — Wed, 20 Feb 2019 15:33:03 GMT

Use the {i} button to post the log, to avoid loss of horizontal formatting.

Re: Update query no longer working

yelkenli — Wed, 20 Feb 2019 15:42:05 GMT

I found the error. It is the use of variable names with a space. I thought I fixed that but was not looking closely enough.

topic Update query no longer working in SAS Programming

Update query no longer working

Re: Update query no longer working

Re: Update query no longer working