We have the need to produce a large pdf-report (Proc report) with variable left-border-margins prepared for physical book-printing. All odd pages should be produced with left border-margin 3cm, all even pages with margin 4cm. Is this somehow possible? Any ideas, suggestions? Thanks, Karl
... View more
Hi How can I easily read an open Excel-sheet out of the SAS-Program-window of the Excel-SAS Addin? Is there any Statement which I can use instead of "Active Excel Sheet" that works (see attached Screenshot). I know I could save the Excel-sheet, attach it with a library (libname XXX Excel "...") and then read it. But is there any way to do it without saving the sheet (like the predefined statistic routines do it in the Addin). Thnaks Karl
... View more
Hi, the idea is as follows with ODS listing off; you can stop procedure list output with ODS output....; you can direct procedure results (in your case the p values) to datasets, please check exact syntax... finally you macro loop around the Proc glm %macro writep; %do k=1 %to 600; ods output ...out=pdset&k; proc glm; model bodyw = drug var&k drug * var&k; run; %end; proc append base=pvalues data=pdset&k; run; %mend; %writep; hope it helps... sincerly Karl
... View more
Hi I generate a series of PDFs by defining a macro containing some procedures and the PDF definition. Within the macro data to be reported are subsetted for each by-value. Finally the macro is executed with call execute for each by-value. Program is like this... %macro writepdf (byvalue); ODS PDF body="&byvalue..PDF"; * one PDF for each by-value; proc print data=LISTDATA; where Var1="&byvalue"; run; ODS PDF close; %mend; Data _null_; set BYVALUES; Call execute('%writepdf(' !! byvalue !! ')'); run; Is there any faster -more direct- way to produce the PDFs per by group (without multiple reading the LISTDATA-dataset)? Thanks for all answers, Karl
... View more