Hi Tom, Thanks for the Insert suggestion. That seemed to be the work-around I needed. I'm trying to append all the views now but am getting an error. I have about 300 views so I've tried to create an array to call in the Set statement so I don't have to list them out but I get an error. Hopefully I'm making an easy mistake. Thanks. data _null_; set LogicTable; /* table that has the viewnames*/ CALL SYMPUT('ViewNames', ViewName); stop; run; data Queued; set &ViewNames; run; Error is with the semicolon after &ViewNames; It says, Line generated by the macro variable "VIEWNAMES". 1 . - 22 ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
... View more