@Shyamkumar wrote:
Hi Team,
I have a 13 columns of dataset, for which I genrated the pdf,but it skips down .In 1st page 9 columns are appearing and remain in 2nd page.
ods listing close;
ods pdf style=sasweb file ="/test/PDF_2S.pdf" ;
proc report data=shyam nowd bypageno=1 spanrows ;
column IDJOB STUDYID PROFILENAME DATATYPE EDUMODULES PARAMNAME
PARAMVALUE ACTION DELETED STATUS STATUSDETAILS USERID TYPE ;
DEFINE IDJOB/DISPLAY"IDJOB";
DEFINE STUDYID/DISPLAY"STUDYID";
DEFINE PROFILENAME/DISPLAY"Filename";
DEFINE DATATYPE/DISPLAY"DATATYPE";
DEFINE EDUMODULES/DISPLAY"EDUMODULES" left style=[cellwidth=width=30mm];
DEFINE PARAMNAME/DISPLAY"PARAMNAME";
DEFINE PARAMVALUE/DISPLAY"PARAMVALUE";
DEFINE ACTION/DISPLAY"ACTION";
DEFINE DELETED/DISPLAY"DELETED";
DEFINE STATUS/DISPLAY"STATUS";
DEFINE STATUSDETAILS/DISPLAY"STATUSDETAILS" left style=[cellwidth=30mm];
DEFINE USERID/DISPLAY"USERID";
DEFINE TYPE/DISPLAY"TYPE";
run;
ods pdf close;
ods listing;
run;
Your output is very likely exceeding the logical width of the page setting that PDF is using.
You might try adding an option to increase the width of the page:
Options papersize=("14in" "10in");
BEFORE the ODS PDF statement. The above would make the page size 14 inches wide by 10 inches long. You can use other measurements such as CM
Reset to the default with Options papersize=Letter; or options papersize=A4; depending on location. (If you don't know what A4 is likely you want letter). There are other named papersizes but finding them involves use of Proc Registry.
