Hi All, The way I've setup my program I extract subsets of data (as tables) from a large dataset. Sometimes these tables are completely empty. Its become a problem since I output these tables onto a pdf and I can sometimes have a number of empty tables. My question is, is there a way to recognise that the entire table is empty so I could skip outputing this table and go to the next? Thanks, Sachin ... View more

Hi All, I can do the following to create an index in the table of contents in a pdf. Proclabel being the main title and contents sub-title (I've set it to nothing i.e. ' ' ). ods proclabel "my table"; proc print data=table noobs contents=''; run; However in a graph I can use the ods proclabel but how do I use the contents statement in a graph. The "plot of y*x=z"(default sub-title) is actually pretty ugly. Thanks, Sachin Message was edited by: SachinRuk ... View more

Hi all, I'm manually adjusting the height of one of my graphs, as a result the tables which are next to them can come on to the same page (which I dont want happening). Is it possible to specify pagebreaks (similar to word) OR specify the page number for a proc gplot? Thanks, Sachin ... View more

Hi All, I've been using nogtitle in my html files to stop graphs printing out a title and a footer I dont want it to print out (because the title is used to put a logo using an escapechar). Either way, how do I get rid of gtitle and gfoot? Thanks, Sachin ... View more

Hi all, I was wondering if it was possible to squeeze a table and graph into one page in a pdf. In a paper I read the guy recommends using 'ods pdf StartsPage=Never;' but this only works for one table and graph. Otherwise squeezes all tables and graphs into one page and makes a huge mess. Any suggestions? Thanks, Sachin ... View more

Hi all, The way I've set up call execute it gets executed so many times that the log keeps asking me to clear it. Is there a way to get around this. I've tried dm 'clear log;'; and options nolog; either of them dont work. Any thoughts? Sachin ... View more

Hi all, I have about 15 graphs in one html file. What I want to do is have a list of names of those graphs and be able to instantly scroll down to those graphs. Rob allison had done something similar with linking to other websites: http://robslink.com/SAS/democd23/overlib.htm http://robslink.com/SAS/democd23/overlib_info.htm but what about linking to graphs within the same file? Thanks in advance, Sachin ... View more

Hi all, Im assuming its one of SAS's basic constraints that stops it from allowing a number from being a var name. Whats happening so far is that (when I do a Proc transpose) it puts an underscore prefix ('_') to it. My question is when I do a proc print how do I get it to display the number instead? Im guessing the answer lies with using labels? Thanks, Sachin ... View more

array time_interval{4}$ 10 ('month','month3','annual','ytd'); do i=1 to 4; %get_calcs(time_interval{i}); end; Hi all, In the abover code the macro get_calcs appends variables with month or whichever name you parse onto it (and it works when i send it when individually typed as month, month3 etc.). However, when I use the array it takes it to be the literal array name instead of value. How do I get arround this? I do know that this has a lot to do with the fact that macros are invoked before the rest of the code. I just want a work around preferably using arrays. I've used call execute but without success since it executes AFTER the data step where the variables are out of scope. does retain help the situation? Thanks, Sachin ... View more

hi all, rsubmit; %macro get_calcs(time); gross_combined_ratio_&time.=(inc_&time.+comearn_&time.)/earn_&time.; %mend; data mydata ; set ba_summary; array time_interval{4}$ 10 ('month','month3','annual','ytd'); do i=1 to 1; call execute('%get_calcs('||time_interval{i}||')'); end; *%get_calcs(month); run; endrsubmit; after running the code i get the error: NOTE: Line generated by the CALL EXECUTE routine. 12 + gross_combined_ratio_month=(inc_month+comearn_month)/earn_month; -------------------------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. any sugestions? Thanks, sachin ... View more

array time_interval{4}$ 10 ('month','month3','annual','ytd'); do i=1 to 4; %get_calcs(time_interval{i}); end; Hi all, In the abover code the macro get_calcs appends variables with month or whichever name you parse onto it (and it works when i send it when individually typed as month, month3 etc.). However, when I use the array it takes it to be the literal array name instead of value. How do I get arround this? Thanks, Sachin p.s. I do know that this has a lot to do with the fact that macros are invoked before the rest of the code. I just want a work around preferably using arrays. ... View more