so i started using this macro a bit late. howwever, i am getting syntax errors. i am running this statement.
%mdsecds(memberfilter="@ID='A5HDAJSI.B90006Y5'");
any idea why? i got the object id from the management console. thanks.
NOTE 137-205: Line generated by the invoked macro "MDSECVW".
80 (location, objname, publictype, ObjId); create view &targdata as select &objcols, &trancols from
____
5 The SAS System 14:26 Thursday, May 7, 2015
22
80 ! &trandata a inner join &objdata b on a.objuri=b.objuri order by location, objname, publictype, objid,
80 ! identityname,
ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (, ',', ANSIMISS, AS, CROSS, EXCEPT, FULL, GROUP, HAVING,
INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, USING, WHERE.
NOTE: Line generated by the invoked macro "MDSECVW".
80 (location, objname, publictype, ObjId); create view &targdata as select &objcols, &trancols from
____
76
80 ! &trandata a inner join &objdata b on a.objuri=b.objuri order by location, objname, publictype, objid,
80 ! identityname,
ERROR 76-322: Syntax error, statement will be ignored.
NOTE: Line generated by the macro variable "TRANCOLS".
80 a.identitydispname, a.identityname, a.identitytype, a.Administer, a.CheckInMetadata, a.Create, a.Delete, a.Read,
80 ! a.ReadMetadata, a.Write, a.WriteMemberMetadata, a.WriteMetadata, a.Alter Table, a.Create Table, a.Drop Table, a.Insert,
_____
22
80 ! a.Select, a.Update
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS,
CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds