@amitr4620 - See this article about determining observation counts efficiently. ... View more

You probably whant to made the macro variable INVIC global, i.e.:   CHANGE %GLOBAL &IVINC;  TO %GLOBAL IVINC; ... View more

@Rikard: I have already done in my scl code.. was trying to do it in a simpler way. ... View more

If you need a macro that gives you the number of rows in a table, the minimum input to this macro needs to be the name of a specific table for which you want the number of rows. E.g.  %check(dsName=sashelp.class); You suggest a solution where you would like to to supply "dsName=100". What kind of input is the value 100? How will this input be used to give you the number of rows in a table?   Perhaps you are not yet familiar with macro functionality and how to call a macro? Then I suggest some reading. E.g. Introduction to the Macro Facility ... View more

If that's the case, it's sounds like the situation I described. We solved that issue by setting IGNORE_READ_ONLY_COLUMNS=YES, which in out case made the columns under automatic constraints be invisible for the SAS client, and not regarded during insert/append operations. ... View more