Dear expert,   I would like to add the table of contents to the pdf that I am generating but changing the option contents=yes, destroy my file, here my code:   ods pdf file='W:\03-OUT_outputfolder\Actuarial_monitoring_report_&date..pdf' contents=yes startpage=yes COLUMNS=2 pdftoc=3 /* controls the table of contents node expansion of a PDF file */ uniform subject="123" author="abc" title="def" style=plateau /*SASdocprinter SASdocprinter journal minimal Plateau*/; goptions htitle=10pt ftext="Helvetica/bold";   any hints? Since it is a quited big pdf (25 pages) it would be nice to have a table of contents. As user of the dear old and efficient Latek I was expecting something similar but the pdf building function of SAS look a bit weird, shaping saveral tables is not so straight forward. Thanks in adcvance for your support, SH ... View more

Dear experts,   I have to report my data in 2 excel sheets, therefore I am usinf the option sheet interval = non but how can I move to the next sheet afterwards? I checke the forum and someone mentioned a bug, any news on it? Thanks a lot in advance for your support.   ods select all; ods excel options( sheet_interval="none" suppress_bylines="yes" sheet_label="sheet2" embedded_titles="yes" embed_titles_once="yes" ); ods excel close %include "W:\04-Programfiles\dashboard\monitoring_S02_claims_as-is_analysis.sas"; ods excel close ;run;   Best regards, SH ... View more

Dear experts,   I have the following data sets:   DATA cost; INPUT cost 4. category $2. product $4. year $4. ; DATALINES; 061 1 ABC 2010 062 1 ABC 2011 067 1 ABC 2012 070 1 ABC 2013 100 1 DEF 2010 105 1 DEF 2011 050 2 GHI 2011 055 2 GHI 2012 060 2 GHI 2013 ;run; DATA revenues; INPUT category $2. product $4. revenue_2010 4. revenue_2011 4. revenue_2012 4. revenue_2013 4. ; DATALINES; 1 ABC 100 098 102 100 1 DEF 120 110 000 000 2 GHI 000 080 075 070 ;run;   In order to calculate the difference between cost and revenues (it is an example, it is about how to do it not why) I need to reshape the both the tables in the same structure. I would like to reshape cost in the form of revenues and viceversal. Any Ideas? I tried with poc mean, proc sql, proc transpose but I did not what I get in a authomatize, quick and elegant manne. Thanks in advance for your reply. BRs, SH   ... View more

Dear experts,   I am trying to display the sum of the variables on a chart (inside=sum) but I do not get what I expect, attached the output and here the code   proc gchart data=mydata_plot; vbar3d month / width=60 WOUTLINE=1 type=sum sumvar=var_tot inside=sum subgroup=&var1. legend=legend1 maxis=axis1 raxis=axis2 space=.4 /*annotate=barlabel*/ frame; title "my data by &var1."; run; quit;   I can plot the data but I get the following warning:  The VBAR/VBAR3D chart for month could not be labeled using INSIDE= because the labels are wider than the bars.   Which is possible solution? Can I somehow display the value in the chart or could I at least print the table with the values under the table? In case yes... how? tahnks a lof in advance for your hints.   BRs, SH ... View more

Dear experts,   I am using the following macro that I found online to import all the xls contained in a folder:   options validvarname=any; %let subdir=G:\xxxxxxt\; filename dir pipe "dir &subdir.*.xls /B"; data new; infile dir truncover end=last; input filename $100.; filename=cats("&subdir",filename); call symputx(cats('path',_n_),filename); call symputx(cats('dsn',_n_),scan(scan(filename,6,'\'),1,'.')); if last then call symputx('nobs',_n_); run; %put _user_; %macro import; %do i=1 %to &nobs; proc import datafile="&&path&i" out=&&dsn&i dbms=excel replace; getnames=yes; mixed=yes; run; %end; %mend import; %import   But I get the error message in the attached picture. Readin some post on the topic I assume that the problem is related to the variable NOBS... why the symbolic reference is not resolved. How should I debug it? Thank in adcance, SH. ... View more