I'm sorry that was my very first post on this site. Does this suffice? 33 Proc Sql;
34 Create Table A As
35 Select distinct
36 A.'ID'n,
37 B.'ITA ID'n,
38 B.'Open Date'n,
39 B.'Due Date'n,
40 B.'ITA Status'n,
41 B.'ITA Completion Date'n
42
43 From DETAILS092222 as A
__
22
2 The SAS System 12:28 Thursday, September 29, 2022
201
ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT,
JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE.
ERROR 201-322: The option is not recognized and will be ignored.
44 inner join ita as B
45 on A.'Id'n = B.'ID'n
46 Order by 1 desc
47 ;
... View more