Hi: I didn't say it wasn't possible. I said you had to have working code for ALL possible types of HAVE files that you need to create. Without working code for ALL possible combinations, you do not know what macro variables or macro conditional logic to code. Given that amount of work, that is why Reeza and others have suggested that you use PROC SQL or some other process to get the data for your report structured the way you want and then use a much simpler PROC REPORT. Probably putting the work in to generate all the possible different combinations of PROC REPORT for ALL your HAVE file scenarios is ultimately the way to go but what if down the road you end up with HAVE6, HAVE7 and HAVE8, 3 new scenarios you didn't previously envision? You'll have to decide which approach is the best approach for the long term. cynthia ... View more

I agree with above comments entirely.   That said,   ReDim Preserve yy(n), xx(n) serves to redimension arrays yy and xx to size n and to keep their current values (up to size n). Array redimensioning doesn't exist is SAS datastep programming.   ... View more

I cannot tell from your post what you are attempting to automate, but let me give you some advice on using lists of values of in macro variables.     If you want to list dataset names or variable names in a macro variable then space delimited is preferred.  You can then use the list in SAS code or pass the value in other macro calls without much trouble.  %let dslist=table1 table2 table3 ; data all ; set &dslist ; run; %let varlist=var1 varB varZ ; proc print ; var &varlist; run; %mymacro(keyvars=&varlist)   But if you want to list labels or other values that could contain spaces then you are better off to use another delimiter, such as |. Otherwise how can you tease them back out again?   %let datasets=dsn1 dsn3 dsn2 dsn4; %let datasets_labels=label for ds1|label for ds3|label for ds2|label for ds4; ... View more

Hi @mlogan,   To see your bookmarks, select the arrow next to your name in the top right area when logged in and select My Subscriptions. You will see My Bookmarks listed on the page.   Kind Regards, Michelle ... View more

As far as I understand, observing the latest user who viewed table is not possible for end user. Well, how can we observe the user by using the server. Can SAS Admin determine the user?   Thank you, ... View more