I tried running it from scratch today and got the same error.
This is what the log says:
28 PROC SQL;
29 CREATE TABLE WORK.updatet1 AS
30 SELECT t1.TimeFrame ,
31 t1.'Counseling on Enrollment Opportu'n as CEO,
32 t1.'Instruction in Self Advocacy'n as ISA,
33 t1.'Job Exploration Counseling'n as JEC,
34 t1.'Work Based Learning Experience -'n as WBLE,
35 t1.'Workplace Readiness Training'n as WRT
36 FROM WORK.updatet t1;
NOTE: Table WORK.UPDATET1 created, with 23 rows and 6 columns.
37 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
38
39 PROC SQL;
40 CREATE TABLE WORK.revisedp1 AS
41 Select * from revisedp ;
NOTE: Table WORK.REVISEDP1 created, with 656 rows and 3 columns.
42 update WORK.revisedp1 as u
43 set u.amount=(select CEO from updatet1 n where u.timeframe =n.timeframe)
_
73
76
ERROR 73-322: Expecting an =.
2 The SAS System 12:27 Tuesday, June 24, 2025
ERROR 76-322: Syntax error, statement will be ignored.
44 where u.rsaservicecategory = 'Counseling on Enrollment Opportu';
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
45 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
46
47
48
49
50 PROC SQL;
51 CREATE TABLE WORK.revisedp1 AS
52 Select * from revisedp ;
NOTE: Table WORK.REVISEDP1 created, with 656 rows and 3 columns.
53 update WORK.revisedp1 as u
54 set u.amount=(select 'Counseling on Enrollment Opportu'n from updatet n where u.timeframe =n.timeframe)
_
73
76
ERROR 73-322: Expecting an =.
ERROR 76-322: Syntax error, statement will be ignored.
55 where u.rsaservicecategory = 'Counseling on Enrollment Opportu';
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
56 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
... View more
