topic Re: Generation PDF(Having 13 colums but its skips to down) in SAS Programming

Generation PDF(Having 13 colums but its skips to down)

Shyamkumar — Wed, 18 Nov 2020 18:16:44 GMT

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;

Re: Generation PDF(Having 13 colums but its skips to down)

ballardw — Wed, 18 Nov 2020 19:04:22 GMT

@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.

Re: Generation PDF(Having 13 colums but its skips to down)

Shyamkumar — Mon, 23 Nov 2020 13:24:18 GMT

Thanks for your response. But it's not working in SAS studio even given the paper size option.