Architecting, installing and maintaining your SAS environment

%mdsecds syntax error?

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

%mdsecds syntax error?

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


Accepted Solutions
Solution
‎05-07-2015 08:14 AM
Occasional Contributor
Posts: 13

Re: %mdsecds syntax error?

Hi,

this is really strange because the documentation shows the same sample code as your code.

The macro variables &objcols or &trancols might be empty, so the sql statement cannot be executed.

Have you tried to provide a path to start your search?

Daniela

View solution in original post


All Replies
Solution
‎05-07-2015 08:14 AM
Occasional Contributor
Posts: 13

Re: %mdsecds syntax error?

Hi,

this is really strange because the documentation shows the same sample code as your code.

The macro variables &objcols or &trancols might be empty, so the sql statement cannot be executed.

Have you tried to provide a path to start your search?

Daniela

Contributor
Posts: 45

Re: %mdsecds syntax error?

thanks daniela.  i put specified the path to the object and it ran without any problem.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 641 views
  • 1 like
  • 2 in conversation