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
... View more
